V
VJ
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.
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.