How to get count of rows in a named range?

[doofusboy]

I would have thought:

ThisWorkbook.Names("MyNamedRange").RefersToRange.Rows

-OR-

ThisWorkbook.Names("MyNamedRange").RefersToRange.Count

-OR-

ThisWorkbook.Names("MyNamedRange").RefersToRange.Rows.Count

All give me 'Invalid use of propert error'.

Any help appreciated.

 

[Weaver]

Range("MyNamedRange").Rows.Count

 

[Andrew Poulsom]

This worked when I tried it:

MsgBox ThisWorkbook.Names("MyNamedRange").RefersToRange.Rows.Count

 

[doofusboy]

Thanks everyone for your responses.

.Rows.Count is working for me now.

Am quessing IDE was in error state because this started working after closing and reopening the file.