worksheets.add

  1. L

    worksheets.add - can I add and name a sheet at same time

    Hi I know how to add a sheet using worksheets.add function but I wonder if I can name it as same time. The function syntax does not show any argument for name! Thanks you Function Add([Before], [After], [Count], [Type]) As Object
  2. L

    VBA - Creating Pivot Tables in New Sheets using Dynamic Objects ?

    Greetings, I am trying to solve in VBA how to create pivot tables in new sheets using objects instead of relying on the sheetcounter, which errors out. :confused::banghead: I found an old Tip on Mr. Excel: Excel Create and name a new worksheet with VBA But I can't figure out how to apply the...
  3. S

    Add n sheets with a "For cycle" and name them using the name ina range

    Hallo guys, -Windows XP -Excel 2010 I need to add 3 new spreadsheets giving them a name taken from a range in another sheet. I used the code below, but after that excel creates the first new spreadsheet with the correct name, it creates the second sheet with the generic name (ex. Sheet17) and...

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