Sub selectsheetfromcellvalue()
Sheets(ActiveCell.Value).Select
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"merry_fay" wrote in message
...
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