[RESOLVED] n00b Needing help.

[Jenewine]

Here is the thing. This is the best way to give u an example.: http://aaahcs.com/excel/test4paf.xlsx In the (D) column you see it says "click to email". I dont want it to say that, i want it to say tha actual email address that it is supposed to say. What ive been doing is right click D1, left click edit hyperlink and then copy email address to the TEXT TO DISPLAY area. then click. But this is getting strenuous. Because i need to do 4000 of those.
I saw a code that looked like it might work, but i couldnt edit it to make it work. So can someone pls help me.

Sub MakeEmails()
For Each e_address In Range("A1:A45")
ActiveSheet.Hyperlinks.Add Anchor:=e_address, Address:="mailto:" & e_address.Value, TextToDisplay:=e_address.Value
Next
End Sub

matter fact i just noticed, i need it to go backwards. I need the TEXT TO DISPLAY to display whats in the Email Address . Preferably without the mailto: in it.im trying to reverse it but dont know how.