I have an activeworkbook which refers to one of the sheet in addIn.

My activeworkbook referes to one of the sheet in the addin
([addInWB]DIV_Sheet !J$8:N$16).

Now I need to refer to different sheet with the same name For example

Lets say I have two sheets DIV_Sheet and Div_Sheet1, Now I need to rename
Div_sheet to Div_Sheet1. My problem is that while renaming the sheets, my
activeworkbook updates to Div_Sheet1 which i need to stop it and should refer
to new Div_sheet.

Please give me some advice.

Thanks in advance.

INDIRECT("[addInWB]DIV_Sheet !J$8:N$16") ?

--

HTH

RP

"VJ" wrote in message
...
I have an activeworkbook which refers to one of the sheet in addIn.

My activeworkbook referes to one of the sheet in the addin
([addInWB]DIV_Sheet !J$8:N$16).

Now I need to refer to different sheet with the same name For example

Lets say I have two sheets DIV_Sheet and Div_Sheet1, Now I need to rename
Div_sheet to Div_Sheet1. My problem is that while renaming the sheets, my
activeworkbook updates to Div_Sheet1 which i need to stop it and should
refer
to new Div_sheet.

Please give me some advice.

Thanks in advance.