LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How to determine within a macro if a cell contains a hyperlink.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to hyperlink a macro from a cell rhhince Excel Worksheet Functions 1 December 25th 06 08:58 PM
How do I create a hyperlink to a cell with the hyperlink function S. Bevins Excel Worksheet Functions 2 July 20th 06 08:06 PM
macro to compare multiple cells to determine value macrodummy Excel Worksheet Functions 2 October 9th 05 01:21 PM
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? Daniel Excel Worksheet Functions 1 June 23rd 05 07:53 PM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"