Test for Hyperlink
I need a simple Boolean function that will return TRUE if a cell contains a
hyperlink, otherwise FALSE.
For example, if A1 contained a hyperlink or contained a formula like
=HYPERLINK("http://www.cnn.com","news")
then haslink(A1) would return TRUE.
--
Gary's Student
|