macro that can jump to a sheet...

B

beatrice25

that is named in a cell e.g. the macro will read cell a1, (where cell
a1 = girls), the macro will then select(or go to) the sheet named
"girls".Any ideas???

BR

B
 
B

bgeier

Sub SelectSheet()
Dim strSheetName As String
strSheetName = Cells(1, 1).Value
ThisWorkbook.Worksheets(strSheetName).Select
End Sub
 
Top