Define sheet name then select sheet

M

merry_fay

Hiya,

I've typed the name of the sheet I want to go to in a cell in excel & used
the macro to define it, but then I can't seem to get the code right for using
that definition to activate the sheet.

sheet_name = ActiveCell.Value
Sheet sheet_name.Select (I've tried lots of different ways of writing this...)

Can anyone help?

Thanks
merry_fay
 
C

Chip Pearson

Try

ThisWorkbook.Sheets(sheet_name).Select


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
C

Carim

Hi,

Just try :

Dim sheet_name As String
sheet_name = ActiveCell.Value
Sheets(sheet_name).Select

HTH
 
Top