+ Reply to Thread
Results 1 to 1 of 1

Select cell containing hyperlink after activation

  1. #1
    Forum Contributor
    Join Date
    02-01-2008
    Location
    Perth, Australia
    MS-Off Ver
    Excel 365
    Posts
    135

    Select cell containing hyperlink after activation

    Hi All,

    I have the below code(a little scrappy), that loops through column A in a worksheet looking for hyperlinks, opening the link copying the information and then pasting it back into the sheet containing the hyperlinks.
    It then goes to the next hyperlink and repeats this.
    The problem with this code is that the hyperlink selection code does not activate the cell containing the link and as such I have no reference point to paste the copied information too.

    Can anyone suggest a fix for this.

    The hyperlinks in the sheet change continualy.

    Please Login or Register  to view this content.
    Cheers
    Last edited by Zimbo; 05-27-2009 at 08:11 AM. Reason: Used alternate method

+ 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