Reference sheets named by DAY
try:
With Sheets(CStr(Day(Date)))
'Do some stuff
End With
Regards
Claus B.\
Thanks, Claus.
Hmmm, new stuff for me. I find this as to describe CStr but very little on examples.
CStr Converts an expression to string data type
Is there a short "how it works" or is it best understood to "go to school" on the function?
Howard
|