sjmoorecouk

Member since 2012

3 snippets

3840 profile views

0 Comment(s) Posted

View their favorites

their Tags

excel sql server function

Profile

Achievement

sjmoorecouk's Recent Snippets

All /

« Prev 1 Next »

Visual Basic Return File Reference

Used to invoke a GetSaveAsFileName dialogue box

excel

0 1671 posted 14 years ago by sjmoorecouk

SQL Return last day of month

Input: Month and year number Output: Last day of month

server
sql

0 1658 posted 14 years ago by sjmoorecouk

Visual Basic Summary Numerical Count

Counts numbers and places the result in row 1. To get this populated click an top row (any) cell and click Yes to the following dialogue box. Only uniquely counts number values, not text.

excel

0 1589 posted 14 years ago by sjmoorecouk