How to find the number of rows in a named range?

A

Andy Chan

Dear all,

I have a named range called "rng" in a worksheet. How can I write a
function to count the number of rows in "rng"? It seems that
"rng".rows.count does not work.

Best Regards,
Andy
 
D

Dave Peterson

msgbox worksheets("sheet99").range("rng").rows.count

if that range is a single area.
 
P

Peo Sjoblom

You can also use a built in function

=ROWS(Rng)

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top