macro that can jump to a sheet...
 

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


--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505
View this thread: http://www.excelforum.com/showthread...hreadid=543110

macro that can jump to a sheet...
 

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


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=543110

macro that can jump to a sheet...
 

Grazie mille , functions well

B


--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: http://www.excelforum.com/member.php...o&userid=34505
View this thread: http://www.excelforum.com/showthread...hreadid=543110