|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 27th, 2004, 05:30 PM
|
|||
|
|||
Another Hyperlink Question
Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to another sheet. This will take too long to do manually, so I was wondering what would be the best way of extracting these hyperlinks.
Thanks, Roger (Ireland) 
|
|
#2
July 27th, 2004, 07:31 PM
|
|||
|
|||
|
Another Hyperlink Question
Hi
see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm and look for: Working with hyperlinks in Cells (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to another sheet. This will take too long to do manually, so I was wondering what would be the best way of extracting these hyperlinks. Thanks, Roger (Ireland)
|
|
#3
July 28th, 2004, 01:18 PM
|
|||
|
|||
|
Another Hyperlink Question
Thanks, Frank. However I'm not familiar with using VBA. Do I add this as part of a macro, assign it to an icon, or how do I get this code to work?
Regards, Roger "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm and look for: Working with hyperlinks in Cells (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to another sheet. This will take too long to do manually, so I was wondering what would be the best way of extracting these hyperlinks. Thanks, Roger (Ireland)
|
|
#4
July 28th, 2004, 07:29 PM
|
|||
|
|||
|
Another Hyperlink Question
Hi
yes this is part of a macro. On the same site is a very good introduction to macros -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Thanks, Frank. However I'm not familiar with using VBA. Do I add this as part of a macro, assign it to an icon, or how do I get this code to work? Regards, Roger "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm and look for: Working with hyperlinks in Cells (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to another sheet. This will take too long to do manually, so I was wondering what would be the best way of extracting these hyperlinks. Thanks, Roger (Ireland)
|
|
#5
July 28th, 2004, 11:43 PM
|
|||
|
|||
|
Another Hyperlink Question
Here's a direct link:
http://www.mvps.org/dmcritchie/excel/getstarted.htm Frank Kabel wrote: Hi yes this is part of a macro. On the same site is a very good introduction to macros -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Thanks, Frank. However I'm not familiar with using VBA. Do I add this as part of a macro, assign it to an icon, or how do I get this code to work? Regards, Roger "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm and look for: Working with hyperlinks in Cells (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany RogerT wrote: Hi - I have a long list of names. Each of these names contains a non-displayed hyperlink (one hyperlink per cell). I want to copy only the hyperlinks to another sheet. This will take too long to do manually, so I was wondering what would be the best way of extracting these hyperlinks. Thanks, Roger (Ireland) -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Insert/Edit HyperLink not working correctly | brmauer | Powerpoint | 3 | June 24th, 2004 03:31 PM |
| Multiple hyperlink and followed hyperlink styles | skellis | Formatting Long Documents | 3 | June 17th, 2004 10:18 PM |
| Hyperlink with copy value to target cell | Sachin | Worksheet Functions | 5 | April 2nd, 2004 05:44 PM |
| Inserting A Hyperlink Automatically | Steve Mulhall | Worksheet Functions | 2 | October 24th, 2003 04:14 PM |
Linear Mode
