Excel VBA - go to worksheet "name" based on a cell reference ="Name"
 

Hi,

I need to open/activate a worksheet based on the text in a cell.

Eg. Cell G21 in Worksheet "Main Menu" = Jun 04

I need to open worksheet named "Jun 04" based on the cell reference.


Thanks for help.

James

--
Message posted from http://www.ExcelForum.com

Excel VBA - go to worksheet "name" based on a cell reference ="Name"
 

Hi James
Worksheets(Range("G21").Value).Activate

HTH
Cordially
Pascal

"james007 " a écrit dans le
message de ...
Hi,

I need to open/activate a worksheet based on the text in a cell.

Eg. Cell G21 in Worksheet "Main Menu" = Jun 04

I need to open worksheet named "Jun 04" based on the cell reference.


Thanks for help.

James.


---
Message posted from http://www.ExcelForum.com/

Excel VBA - go to worksheet "name" based on a cell reference ="Name"
 

Thanks for your help Pascal, and I appreciate the promptness of you
reply.

Thanks.

James

--
Message posted from http://www.ExcelForum.com