ok here is how i do it.cell a1 has the formula=text(B2,d,mmm,yyyy).I type the
date in cell b2 and the answer is 8,may,2005,so the worksheet tab naming
regime has to match the format of the date or visa versa.(ie the tab has to
be 8,may,2005)Your original code then works a treat.
--
hope this helps
Paul


"camerons" wrote:

Unfortunately that does not seem to help. Due to manipulation by the user,
I don't know what order the sheets will be shown. The only consistent info
I have is that the sheet will be named what day it was worked on. I need my
code to reference that variable name and error check.

Is there any way for SheetOLD.select to accept OLD as a variable name?