What is the proper VBA syntax to check if a cell contains a hyperlink

[webster188]

Title is self-explaining.

Looking for a way to check if a cell on a worksheet has a hyperlink defined.

Regards,

Dimitri

 

[steve the fish]

Id use something like this:

If Range("A1").Hyperlinks.Count > 0 Then MsgBox "hyperlink present!"