+ Reply to Thread
Results 1 to 3 of 3

macro that can jump to a sheet...

  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    93

    Red face 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

  2. #2
    Forum Contributor
    Join Date
    08-07-2004
    Location
    Ohio, USA
    Posts
    114
    Sub SelectSheet()
    Dim strSheetName As String
    strSheetName = Cells(1, 1).Value
    ThisWorkbook.Worksheets(strSheetName).Select
    End Sub

  3. #3
    Registered User
    Join Date
    05-16-2006
    Posts
    93
    Grazie mille , functions well

    B

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1