software

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
quot;girlsquot;.Any ideas???

BR

B--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543110
Sub SelectSheet()
Dim strSheetName As String
strSheetName = Cells(1, 1).Value
ThisWorkbook.Worksheets(strSheetName).Select
End Sub--
bgeier
------------------------------------------------------------------------
bgeier's Profile: www.excelforum.com/member.php...oamp;userid=12822
View this thread: www.excelforum.com/showthread...hreadid=543110
Grazie mille , functions well

B--
beatrice25
------------------------------------------------------------------------
beatrice25's Profile: www.excelforum.com/member.php...oamp;userid=34505
View this thread: www.excelforum.com/showthread...hreadid=543110