View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jwb96@hotmail.com is offline
external usenet poster
 
Posts: 2
Default Script to recognize hyperlinks?

I'm using a for each...next loop to examine a range of cells that was
brought in through a web query. For each cell, I need to evaluate if
it's hyperlinked and if so, if it has text in it or is a blank cell
with a hyperlink or is a cell with text buy no hyperlink. What do I
put in my if statements to distinguish these possibilities?

TIA,
Jim