Hi Howard,

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

CStr Converts an expression to string data type

Sheets(20) is the 20th sheet in the workbook.
Sheets("20") is your sheet named by day.
Day(Date) is a numeric value and would refer to the 20th sheet.
So you have to convert Day(Date) to string.


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