Hi Howard,

Am Tue, 20 Jan 2015 03:04:49 -0800 (PST) schrieb L. Howard:

How do I reference the sheet named 20 (for the day of the month), then tomorrow the With Sheets("20") will be With Sheets("21")?

try:

With Sheets(CStr(Day(Date)))
'Do some stuff
End With


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional