Activate Worksheet via cell contents in VBA?

[BLaCKouT]

Morning all, Just a quick one:

I've got several worksheets in a book, all uniquely named (obviously). I've also got an 'Info' worksheet, with a dynamic worksheet-name (one of the previously mentioned) in cell L7 stored as text.

• In VBA, can I activate the worksheet named in that location?

Been playing with it but can't get it to work, and I can't seem to find the subject online anywhere, but I'm sure I can't be the first person who's wanted to do it

Many thanks in advance,
B.

 

[Mike Blackman]

Hi,

Try this;

Sheets(Range("L7").Value).Activate

 

[BLaCKouT]

Mike, you're awesome. The next time I'm in Basingstoke, I'm bringing you some biscuits

I was trying to make it way more complicated than it needed to be (no surprise there).

Thank you v.much!

 

[Mike Blackman]

Chocolate Hobnobs please