Change email address to hyperlink w/Macro

[dkub]

I have a workbook with several sheet within and in column ther may or may not be e-mail addresses. If there is an e-mail address I want to make it hyperlink ready, I don't want to follow it or execute just make it available to be clicked on. I have some code that I am using to loop through the book and it's sheets.

Please Login or Register  to view this content.

Hope this help someone that can help me - thanks in advance

[tigeravatar]

dkub,

Give this a try:

Please Login or Register  to view this content.

Hope this helps,
~tigeravatar

[Leith Ross]

Hello dkub,

I made a few changes to macro to add the hyperlinks for email addresses.

Please Login or Register  to view this content.

[dkub]

Thanks - bunchs they both work just fine - great help - thanks again