Function IsHyperlink(r As Range) As Integer
IsHyperlink = r.Hyperlinks.Count
End Function
=IF(IsHyperlink(A1),"LINK","NO LINK")
Thank you.Short answer, no.
You have to create a UDF like below. Create a standard module and paste the code:
Then you can use UDF like:VBA Code:Function IsHyperlink(r As Range) As Integer IsHyperlink = r.Hyperlinks.Count End Function
Excel Formula:=IF(IsHyperlink(A1),"LINK","NO LINK")
Thank you.Short answer, no.
You have to create a UDF like below. Create a standard module and paste the code:
Then you can use UDF like:VBA Code:Function IsHyperlink(r As Range) As Integer IsHyperlink = r.Hyperlinks.Count End Function
Excel Formula:=IF(IsHyperlink(A1),"LINK","NO LINK")