sjmoorecouk

Member since 01/31/2012

Name: Stephen Moore

Location: St.Marys Island

Website: www.sjmoore.co.uk

3 snippets

677 profile views

0 Comment(s) Posted

View their favorites

their Tags

excel sql server function

Profile

Achievement

first submission:submitting first snipplet

sjmoorecouk's Recent Snippets

All /

« Prev 1 Next »

Visual Basic Return File Reference

Used to invoke a GetSaveAsFileName dialogue box

excel

0 331 posted 10 years ago by sjmoorecouk

SQL Return last day of month

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

server
sql

0 368 posted 10 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 321 posted 10 years ago by sjmoorecouk

« Prev 1 Next »