[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[_2_]]

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.

[Ted Stilwell]

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

"Shane Devenshire" wrote in
message ...
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.