+ Reply to Thread
Results 1 to 5 of 5

VBA to Hyperlink sheets from cell values in a range

  1. #1
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    VBA to Hyperlink sheets from cell values in a range

    I have a list on numbers in a range and I have sheet names that include a prefix and the number. I am trying to set a hyperlink on each cell in the range. I've been trying to loop through the range and set it but it keeps setting the page addresses to the last value in the range. I've tried a bunch of different thing but I keep getting the same result. Here's the last thing I tried.
    Please Login or Register  to view this content.
    Any help would be greatly appreciated, and I'm open to suggestion for other methods to do this. BTW the range in the selection is dynamic.

    Thanks! Tom
    Tom S.
    ↙ If you find my reply helpful click on the * down there on the left. Yeah that's it, right there, down on the left
    If your question is resolved, mark it SOLVED using the thread tools.

  2. #2
    Registered User
    Join Date
    01-01-2005
    MS-Off Ver
    2007
    Posts
    368

    Re: VBA to Hyperlink sheets from cell values in a range

    Hi,

    If possible attach a dummy file.

    Elio Fernandes

  3. #3
    Valued Forum Contributor
    Join Date
    02-12-2011
    Location
    The Netherlands
    MS-Off Ver
    365
    Posts
    817

    Re: VBA to Hyperlink sheets from cell values in a range

    Try it.


    Please Login or Register  to view this content.
    Kind regards, Harry.

  4. #4
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: VBA to Hyperlink sheets from cell values in a range

    Perfect HSV! TY very much!

    I missed the "Anchor:" part or I would have had it with a previous try.

  5. #5
    Forum Contributor
    Join Date
    09-27-2012
    Location
    Florida
    MS-Off Ver
    Excel XP to 2013
    Posts
    342

    Re: VBA to Hyperlink sheets from cell values in a range

    Elio, I was creating a file when I saw HSV's reply. TY for the reply.
    This will be great for creating Index pages for large workbooks with lots of sheets.

+ 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