G
greg
This should be an easy question
If I have multiple workbooks open.
Each workbook is assigned to a var. such as
WB1, WB2, etc...
If I have a name range. Such as "NameRange1"
How do I get the values from each workbook. Without knowing the worksheet.
Range("NameRange1") seems to get only the active workbook.
There does not seem to be a WB1.Range method. On the workbook.
Can you do this without Activate on each workbook?
thanks
If I have multiple workbooks open.
Each workbook is assigned to a var. such as
WB1, WB2, etc...
If I have a name range. Such as "NameRange1"
How do I get the values from each workbook. Without knowing the worksheet.
Range("NameRange1") seems to get only the active workbook.
There does not seem to be a WB1.Range method. On the workbook.
Can you do this without Activate on each workbook?
thanks