Ahhh .. Never mind ... I'll just open it READ ONLY instead (was
worried about it being locked if another user tried to open it).

Regards

Greg


On Jan 31, 3:45 pm, "Greg Glynn" wrote:
Can I enquire on the size of a range in an unopened worksheet?

The line below doesn't work:
J = Workbooks("C:
\MyTables.XLS").Worksheets("cs_Tables").Range("CS_ Names").Rows.Count

Thanks in advance,

Greg