sjmoorecouk

Member since 01/31/2012

Name: Stephen Moore

Location: St.Marys Island

Website: www.sjmoore.co.uk

3 snippets

2604 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 1285 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 1256 posted 13 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 1194 posted 14 years ago by sjmoorecouk