+ Reply to Thread
Results 1 to 2 of 2

Select worksheet from cell value

Hybrid View

  1. 06-16-2009, 11:54 AM #1
    Directlinq
    Directlinq is offline
    Forum Contributor
    Join Date
    10-24-2008
    Location
    England
    Posts
    146

    Select worksheet from cell value

    I have this but does not work.

    In a3 i have a name corrisponding to a worksheet name
    How can i select this worksheet ?


    Sheets = Range("a3").Select
    Many Thanks
    Reply With QuoteRegister To Reply
  2. 06-16-2009, 11:59 AM #2
    Phil_V
    Phil_V is offline
    Forum Contributor
    Join Date
    02-23-2006
    Location
    Near London, England
    MS-Off Ver
    Office 2003
    Posts
    770

    Re: Select worksheet from cell value

    Nearly!

    Sheets(Range("A3")).Select
    If you find the response helpful please click the scales in the blue bar above and rate it
    If you don't like the response, don't bother with the scales, they are not for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1