Try,
Dim ss As String
ss = Sheets("Sheet60").Range("d2").Value
Sheets(ss).Select
Mike
"RobN" wrote:
(I posted this in the office.misc newsgroup by mistake)
I've used the following to try and have VB select a sheet dependant on the
value in d2.
Dim ss As Variant
Set ss = Sheet60.Range("d2")
How do I apply that now to select that sheet? I thought something like
sheet(ss).select would do it, but it doesn't work
Sheets(ss).select does work, but doesn't go to the correct sheet number,
whereas Sheet(ss) brings up a "Sub or Function not defined" error.
Rob