copy a range from one workbook to a new workbook

  1. P

    Macro to save different departments on new sheet

    Hello, I have two sheets, Actuals Pivot Table and AllDepts. Actuals Pivot table has pivot table data in A-G and AllDepts has a list in column C as below. There are 30 departments on the AllDepts tab. I am looking for a code to loop through the department list above and for each department...
    • pgd2
    • Thread
    • copy a range from one workbook to a new workbook excel vba
    • Replies: 0
    • Forum: Excel Questions
  2. N

    How to copy a range from 1 workbook to a new workbook and avoid subscript out of range error

    I am trying to copy a range from 1 workbook to a new workbook, but I keep getting subscript out of range and I don't know how to fix it. The workbook still has no name, since I still have not saved it, since I am going to save it until all my code executes. Any help will be greatly apperciated...
    • nando88
    • Thread
    • copy a range from one workbook to a new workbook subscript out of range vba
    • Replies: 1
    • 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