Hi,

Try this VBA function

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

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Ted Stilwell" wrote:

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.