reference workbook

  1. C

    How to set another workbook as a variable

    I am trying to set an open workbook as variable book2 but keep getting a 'Subscript out of range' error. Below is the code I am working with. It errors at 'Set book2'. It's completely random and will work sometimes but most of the time it doesn't. Could someone help? Set book1 = ActiveWorkbook...
    • chrissnead
    • Thread
    • reference workbook run-time error '9' subscript out of range vba workbook
    • Replies: 14
    • Forum: Excel Questions
  2. L

    Destination workbook does not auto update when i change the source workbook.

    Hello Mr. Excel, i have an urgent problem for you to help. first, i created a main source workbook, and then i linked it with more than 10 destination files. when i use excel 2010, my destination file will auto update when i change on the main source file although i dont open the file. However...
    • Legacy 358300
    • Thread
    • destination file main source workbook reference workbook
    • Replies: 10
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top