you can do this
myvariable = 'your variable here
Sheets(myvariable).Select 'no quotes required
But if I understand correctly you need the variable to be available AFTER
the worksheet has been modified and saved and closed?

--
hope this helps
Paul


"camerons" wrote:

I am currently using a workaround where I have a "static-named" "Archive"
worksheet that the previous days data gets stored to. When the new days
data gets refreshed then the archive data gets saved to a seperate file with
the name of the workday it was made, and the archive sheet gets updated.
This forces an extra step in the process, but until I figure out how to
select a worksheet named with a variable..............