Hyperlink address

Hi,
Is there any way to copy the hyperlink destionation from a hyperlink field?
I have a few hundred hyperlink cells and I have to list the hyperlink
destinations.
Thank you!

are you trying to copy the hyperlinked cells and paste them elsewhere??

of are you trying to get all the hyperlink address's?

Originally Posted by Carim

Hi,

with a UDF ...

Please Login or Register  to view this content.

Can you please be more explicite?

I never coded in Excel before. Can you tell me how to do it?

Thank you!

Originally Posted by Stuie

are you trying to copy the hyperlinked cells and paste them elsewhere??

of are you trying to get all the hyperlink address's?

I want to remove the text and display only the hyperlink adress.

Thank you!