Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created an excell worksheet which is a "pasting" of information off of
a web page that contains hyperlinks. I now want to use an excell macro to determin which cells contain the pasted hyperlinks. Please note that the "pasting" is created by selecting and then copying the part of the web page I am looking at. As such, when I paste in excell it does maintain the hyperlink, but when one looks at the cell contents that contains a hyperlink it looks like text (i.e. there is no "=HYPERLINK ..." construct) yet is is underlined and colored indicating that it is a hyperlink and when one click on it it goes to the hyperlink. Thus, I am looking for a method to determine if a cell contains a hyperlink via an excell macro. I am using Excell 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to hyperlink a macro from a cell | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
macro to compare multiple cells to determine value | Excel Worksheet Functions | |||
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |