Loop thru hyperlinked cells and format hyperlink

[kosherboy]

Hello,
I need to change thousands of hyperlinks so i figured the way to do it the quickest would be with a macro.
So the below code only on a selected cell and does not loop thru the range that i set the code to.
Hoping for someone to help me out on this and point out where the mistake is.
Thanks.

Please Login or Register  to view this content.

[humdingaling]

not sure what formatting your doing but not sure you can loop hyperlinks like that

make it loop the range and check if cell has hyperlink instead

Please Login or Register  to view this content.

[kosherboy]

Thank you for your reply.
So it makes sense what you are saying but i could not figure out how to get the hyperlink to actually work.