Just add the line
At the end of your code you just provided and that should hopefully workActiveSheet.Hyperlinks.Add Anchor:=ActiveCell, Address:= "mailto:" & activecell.value, TextToDisplay:=activecell.value
Just add the line
At the end of your code you just provided and that should hopefully workActiveSheet.Hyperlinks.Add Anchor:=ActiveCell, Address:= "mailto:" & activecell.value, TextToDisplay:=activecell.value
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks