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

  • Thread starter Thread starter Andy Chan
  • Start date Start date
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
 
msgbox worksheets("sheet99").range("rng").rows.count

if that range is a single area.
 
You can also use a built in function

=ROWS(Rng)

--
Regards,

Peo Sjoblom

(No private emails please)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selection within a named range 8
Dynamically assign macro 23
Advanced Filter Error - I cannot spot my Error 3
End process at last row of data 3
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Macro to email via MAC (Code for Outlook working) 1
Find: runtime error 1004 Application-defined or object-defined error 3
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 1

Back
Top