View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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