I have a situation where I'm trying to create a loop that opens a worksheet
that has the same name as a range or cell or variable. I can capture the
name from the value in a cell, but then when I try to use that name as the
name of the worksheet I get a datatype conflict. Here's an example from the
code...

Set NextTab = Users(UserLoop) ' where Users & NextTab are defined as
ranges
Set WS1 = Worksheets(NextTab) ' can't use a range this way

Any way around this?
Thanks,
Steve