Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
range question | Excel Programming | |||
Range question | Excel Programming | |||
Used Range Question | Excel Programming | |||
Range.Formula and Range question using Excel Automation | Excel Programming |