Re: macro that can jump to a sheet...

Giganews Newsgroups
Subject: Re: macro that can jump to a sheet...
Posted by:  bgeier (bgeier.27z4pm_1147906502.2155@excelforum-nospam.com)
Date: Wed, 17 May 2006

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?action=getinfo&userid=12822
View this thread:http://www.excelforum.com/showthread.php?threadid=543110

Replies

In response to

macro that can jump to a sheet... posted by beatrice25 on Wed, 17 May 2006