We help IT Professionals succeed at work.

How to find row & col limits in a named range?

mlagrange
mlagrange asked
on
Medium Priority
252 Views
Last Modified: 2012-06-27
Hello - is there a similar property for named ranges as there is for worksheets?
MyWks.UsedRange.Rows.count
MyWks.UsedRange.Columns.count

Thanks
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Try

Range("MyRange").rows.count
Commented:
Example below:

Sub range_spec()
  MsgBox (Sheets("MyWks").Range("UsedRange").Columns.Count)
  MsgBox (Sheets("MyWks").Range("UsedRange").Rows.Count)
End Sub

Author

Commented:
I apologize for taking so long to close this out; I got pulled away on other things, and forgot this was still out there.
Thanks for your responses.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.