Finding the Size of a Range in an Unopened Worksheet
 

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

Finding the Size of a Range in an Unopened Worksheet
 

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