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
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
Sub SelectSheet()
Dim strSheetName As String
strSheetName = Cells(1, 1).Value
ThisWorkbook.Worksheets(strSheetName).Select
End Sub
Grazie mille , functions well
B
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks