Check for hyperlink

  • Thread starter Thread starter Jan Kronsell
  • Start date Start date
In code or manually?

In code:

if activecell.Hyperlinks.Count = 0 then
'no hyperlink
else
'yep
end if

Manually, I'd just mouse over the cell--or ctrl-k to see what shows up.
 
Thank you - code it is then. I just thought that there might be a function
like ISNUMBER but then I'll just make my own .-)

Regards
Jan
 
Back
Top