79532287

Date: 2025-03-24 22:27:59
Score: 3
Natty:
Report link

Named Ranges have their own references.

Try :

ThisWorkbook.Names("MyArray").RefersToRange.Columns.Count

ThisWorkbook.Names("MyArray").RefersToRange.rows.Count

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Unregistered user (0.5):
  • Low reputation (1):
Posted by: Frank