Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert email hyperlink
Excel2003-
I have a very long column of email hyperlinks pasted in from a website. They look like envelope pictures. To change them to text, I have to point to the envelope, so the cursor changes to a hand, rightclick, edit hyperlink, copy to adjacent column.... The macro I recorded looks like this: Keyboard Shortcut: Ctrl+b ' ActiveSheet.Shapes("Picture 1").Select ActiveCell.Offset(0, 1).Range("A1").Select ActiveSheet.Paste ActiveCell.Offset(1, -1).Range("A1").Select End Sub Of course, the macro keeps doing its thing on "Picture 1". I'd like it to convert the whole column. I'm stuck--Any help? And yes, VBA is a foreign language to me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hyperlink function into hyperlink | Excel Worksheet Functions | |||
convert hyperlink to email address | Excel Programming | |||
How to Hyperlink in an email? | Excel Discussion (Misc queries) | |||
How to convert Email into Mailto Email Addresses | Excel Worksheet Functions | |||
copy/convert column email addresses Hyperlink "mailto:" excel97 | Excel Discussion (Misc queries) |