View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_190_] ExcelMonkey[_190_] is offline
external usenet poster
 
Posts: 172
Default HasExternalLink Function

I am looking to write a function to see if a cell has an
external link. I know that if it does, it will have:

"="
"["
"]"

I could realistically use .Hasformula property to test
that the cell is a formula and then use the Find Method
with some sort of combined search

..Find([, lookin:=xlValues)
..Find(], lookin:=xlValues)

But is there an easier way to test (Boolean) if a cell has
an external link?