You might try
sheets(1)
sheet1

--
Don Guillett
SalesAid Software

"camerons" wrote in message
...
I'm updating a formatted worksheet every day. I have a macro that
processes, lets the user augment, and then saves that days data into a new
worksheet with that days date. I need to reference that worksheet the
next
business day to error check. I cannot :
PREVIOUS DATE IS IN CELL A1

s = range("a1").value
worksheets(s).select

Thank you for any help/suggestions

Chris Cameron