Code to search for all hyperlinks in a column & copy them to an alternative sheet

Hi all,

I've having limited success with the following code, the code should look for all hyperlinks in a specified column (Sheet "Page4+" Column "G") & copy each one to an alternative sheet ("HL"). The code works if copied to the same sheet ("Page4+") but as soon as I try to redirect the results to a separate sheet the code fails? Any help as always will be greatly appreciated, thank you - Marco

Please Login or Register  to view this content.

Hi all,

Panic over, I retweaked the code & managed to get it to work, see below, thanks anyway guys! - Marco

Please Login or Register  to view this content.