How to check if cell has a hyperlink or not.

[FNR]

I'm using an Excel workbook to record information for genealogical research. Each family sheet has grandparents, parents, and children in assigned cells. Hyperlinks are on the family sheets if further information is known and recorded on other family sheets. If information is not known or the sheet hasn't been created yet there will not be a hyperlink. I have used vb to help with the index sheet to re-hyperlink back to index after any row or column insertion or sort on the index sheet. I have vb to add links to names on a family tree sheet to their family sheet. I want to learn how to check if a cell has a hyperlink or not in vb. I know it must be simple, but I don't know what I don't know and MS Help isn't any help.

[MSP77079]

Not sure if this is what you are looking for or not. It might give you an idea.

Please Login or Register  to view this content.

[FNR]

Thanks for reminding me that I can create an error and handle it. I seldom program utilizing errors and I thought there might be some simple check to see if the select cells have hyperlinks. Your way works for what I am trying to do though. Thanks again.