This has to be a simple deal but I just don't get it. I have a column of email addresses and I would like to copy the 7 email addresses, edit an existing hyperlink, paste in the email address field. If I paste into Notepad and then copy from Notepad to email address it works. I can see through the Office Clipboard that when I copy an Excel cell it won't paste in the email address field - but when I copy it from Notepad the Office Clipboard shows it as text - Boom - it pastes fine. So, I started this convoluted macro to copy, open notepad, paste, copy from notepad and paste in the Hyperlink (that's just crazy). I could use some help, please.