Within the selected range there are several cells that contain the hyperlink formula due to being country based dynamic links example "
Please Login or Register  to view this content.
When the VBA code is run, it takes all the required data, however turns the hyperlinks into simple text. Could anyone support with correcting this. Thanks in advance.


Please Login or Register  to view this content.