You haven't specified which hyperlink to check so I'll just point you at some other threads where people have tested hyperlinks or filepath links
vba - Checking for broken hyperlinks in Excel - Stack Overflow
Excel VBA module to test if hyperlink string refers to valid file - Stack Overflow
Checking validity of hyperlinks in Excel - Microsoft Tech Community
Custom function for checking validity of a hyperlink | MrExcel Message Board

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia