Sub gotosheet()
'goes to sheet1 in order in vba
'no matter what you name it
Sheet1.Select
End Sub
Sub gotosheet1()
'goes to the first TAB as sorted
'no matter what you name it
Sheets(1).Select
End Sub

--
Don Guillett
SalesAid Software

"paul" . wrote in message
...
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?