Activate List of Email Hyperlinks

S

Sharen

I have a column of 700+ email addresses that are not hyperlinked. I know how
to make each individual link live; however, given the number involved, that
would take forever! Does anyone know a way to activie the entire column?

Thanks,
Sharen
 
S

Sharen

Thank you for your help. I've followed the instructions exactly as written,
but I'm getting a "Compile Error" that says "Next without For." The word
'next' is highlighted just before the word "cell" and "end sub."

Problem is... I have no idea how to fix the error. Can you help me with
this? I really appreciate your expertise!

Sharen
 
P

Peo Sjoblom

You need to select all email addresses before you run the macro
1 select the range(s)
2 press Alt + F8 and click run or click tools>macro>macros and click run

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top