Count hyperlinks in a mixed range
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.
|