sjmoorecouk

Member since 2012

3 snippets

3607 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 1599 posted 13 years ago by sjmoorecouk

SQL Return last day of month

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

server
sql

0 1580 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 1522 posted 14 years ago by sjmoorecouk