Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some help refering to Names having duplicate range name.
I have a worksheet1 in wb1 and A1 cell range name is "rng_Data" and I have another worksheet2 in wb2 and its A1 cell range name is also "rng_Data". If I move the worksheet2 into the wb1, then all the ranges also moved to the workbook1. Is there any way I can refers to range "rng_Data" of worksheet1 and worksheet2 separately.? If i look in the names I see two ranges one is rng_Data and other one is rng_Data worksheet2. Can somebody suggest me a way around? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
refering to other workbooks | Excel Discussion (Misc queries) | |||
Refering a cell | Excel Worksheet Functions | |||
Refering to Cells | Excel Worksheet Functions | |||
Change the Range refering to a Name | Excel Discussion (Misc queries) | |||
Refering to Desktop | Excel Programming |