Reference to sheet name in addIn

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to force macros refer to ActiveWorkbook 2
Reference sheets named by DAY 7
Looping through sheets 3
Adding a sheet to a workbook 1
Copy a Sheet to an AddIn 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy two sheets from workbook & create new workbook 8
how to use codenames with an addin? 1

Back
Top