Snipplr - sjmoorecouk http://snipplr.com/users/sjmoorecouk Recent snippets posted on Snipplr.com en-us Wed, 22 May 2013 20:10:47 GMT (Visual Basic) Linked Chart Update http://snipplr.com/view/67919/linked-chart-update/ Relinks chart objects to a new source (where newfile is the variable containing that new full path/file source info)

]]> Thu, 25 Oct 2012 02:53:33 GMT http://snipplr.com/view/67919/linked-chart-update/ (Visual Basic) Return File Reference http://snipplr.com/view/67230/return-file-reference/ Used to invoke a GetSaveAsFileName dialogue box

]]> Tue, 18 Sep 2012 23:01:12 GMT http://snipplr.com/view/67230/return-file-reference/ (SQL) Return last day of month http://snipplr.com/view/66616/return-last-day-of-month/ Input: Month and year number Output: Last day of month

]]> Fri, 10 Aug 2012 00:10:43 GMT http://snipplr.com/view/66616/return-last-day-of-month/ (Visual Basic) Summary Numerical Count http://snipplr.com/view/63381/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.

]]> Fri, 17 Feb 2012 03:36:19 GMT http://snipplr.com/view/63381/summary-numerical-count/