sjmoorecouk

Member since 01/31/2012

Name: Stephen Moore

Location: St.Marys Island

Website: www.sjmoore.co.uk

3 snippets

1462 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 729 posted 12 years ago by sjmoorecouk

SQL Return last day of month

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

server
sql

0 728 posted 12 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 661 posted 12 years ago by sjmoorecouk