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.
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.