I was trying to figure out how to make the "Dim" option work. I knew
there was a way.

Thanks for your help also, Paul.

Dow.

On Feb 19, 12:03*pm, wrote:
Hi
In your macro you should capture the B2 value required *e.g.
Dim MySheetName as String
mySheetName = Worksheets("ShheetWithB2").Range("B2").Value

then you can use that later with

Worksheets(mySheetName).Activate

regards
Paul