Verify Cell is a Hyperlink

[agale]

I have a column of numbers. Each number becomes a part of a hyperlink. The hyperlink is stored in the corresponding cell. When a new number is added to the column I need to scan the column and create a hyperlink for the newly entered number. To avoid redoing every cell I need to check if a cell is already a hyperlink and move on to the next cell creating a hyperlink when I get to a number cell that does not contain a hyperlink. How do I check if a cell contains a hyperlink already. Thanks

 

[TonyJollans]

Hi agale,

Range("D7").Hyperlinks.Count

will give the number of hyperlinks in cell D7, for example. For a single cell it can, I assume, only return the fairly self-explanatory values of zero and one.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[agale]

Thanks, Tony. Worked great! !