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.
Cheers
Bookmarks