Look at this:

Worksheets(Range("B2").Value).Activate

or

X=Range("B2").Value
Worksheets(X).Activate

Hopes this helps.

---
Per

"Dow" skrev i meddelelsen
...
I have searched and searched for this answer but everything I have
found and tried did not work.

The macro I use is very simple. It creats and names a second
worksheet that uses different formulas to return values based on the
data in the first worksheet. I also populate Cell B2 in the new sheet
with the name of the original worksheet.

After the second worksheet is created I want the macro to go back to
the original and make changes -add a column, delete a column, resort,
etc. The name of the first worksheet changes daily.

This code works fine for what I need and so I use it:

Worksheets(1).Activate

But what I want to know how to do, for my own understanding, is how to
Activate a worksheet based on a Cell value. I have tried Indirect and
a number of other things with no luck.

Worksheets(B2).Activate does not work because it is looking for a
worksheet named B2.

Is there an easy way to say Worksheets(X).Activate where "X" is the
text in a Cell like B2?

Thanks,

Dow