Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Referencing Range in UnOpened Workbook | Excel Programming | |||
Testing an unopened (or opened) worksheet for VBA Project protected | Excel Programming | |||
How can I embed a file as an unopened object in a worksheet or wo. | Excel Discussion (Misc queries) | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |