add worksheet

  1. S

    ActiveWorkbook.Sheets.Add not working properly

    I want to add new sheets after the original sheet. I typed ActiveWorkbook.Sheets.Add(After:=ActiveWorkbook.Worksheets(ActiveWorkbook.Worksheets.Count)) but a compile error showed. What's wrong and how to fix that?
  2. H

    Open workbook and add new sheet VBA

    Hi - I have been working in this since yesterday and cannot figure out the last part. The macro works great (Thank you Jerry Beaucaire (4/22/2010)), but I'm having trouble modifying it for the second step. I have a spreadsheet with all vendors listed with their data. A macro is run and all of...
  3. S

    Summary Page Update

    Still learning vba, I have code to copy specific cells from one worksheet to another, currently coded for a specific worksheet. Need to have the code loop through all of the worksheets (to be named by users) that are not labeled Summary or Template. Could someone please, please help. Here is...

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