Rick,
Highlight the range you wish to add email addresses to, then, switch to your
VBE environment by pressing Alt-F11 and go to Immediate Pane by pressing
Control-G and enter the following command
for each rng in selection:rng.hyperlinks.add rng,"mailto:" & rng:next
http://HelpExcel
"Rick Wetzel" wrote:
I have imported a column of email address. How do I make them clickable
links to email.
--
Rick Wetzel