Is there anyway to check if a cell contains a hyperlink? Regards Jan
D Dave Peterson May 22, 2008 #2 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.
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.
J Jan Kronsell May 22, 2008 #3 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
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
