Count hyperlinks in a mixed range

[Ted Stilwell]

I have a range of text cells storing model numbers. As I get the associated
mfg document for the model number I hyperlink that doc to it's model number.
I'd like to be able to count the hyperlinked documents or a range of cells
examining the text range cells to calculate % completion.

Any ideas?

Many thanks in advance.

 

[Shane Devenshire]

Hi,

Try this VBA function

Function CountHL(myRange As Range) As Long
CountHL = myRange.Hyperlinks.Count
End Function

 

[Ted Stilwell]

Shane,
Fantastic! .
I don't see a Yes button but if I did I'd be pushing it.
Thank you again
Ted