copying sheets using vba

  1. B

    Copying a Sheet with a Chart "Run-time error"

    Hi everyone, first post here but been looking at the forums for help for a while. I've been working on automating functions in an Excel Workbook. The workbook is used for tracking the progress resources are making in a project. Each resource has three sheets of data so when starting a project I...
  2. N

    Copy method fails sometimes while copying a worksheet using VBA code

    HI Friends! I am trying to copy worksheets using VBA code .I ask the user how many worksheets he wants to add and then I rename the sheets as they are created one by one.For some attempts (say for 17 sheets) it works fine but after some time it fails and gives error "Copy method of worksheet...

Watch MrExcel Video

This Week's Hot Topics

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
Top