adding sheets

  1. D

    VBA to add new Sheets

    Good evening all I have some code which i have borrowed to add some new sheets to a workbook based on the contents of column a. The code is Sub AddSheets() Dim cell As Excel.Range Dim wsWithSheetNames As Excel.Worksheet Dim wbToAddSheetsTo As Excel.Workbook Set wsWithSheetNames = ActiveSheet...
    • DrH100
    • Thread
    • adding sheets code unique entries vba & excel
    • Replies: 2
    • Forum: Excel Questions
  2. B

    A new to create a Wksheet in a Macro with 10 Tabs

    I need to create a Worksheet within a macro that has 10 tabs. I had something running, then I made some changes and I got Application-defined or object defined error. Sheets("Sheet1").Name=Sheetname(1) Sheets.Add after:=Sheets(Sheets.Count) I was looping thru this up to 10 now its not...
  3. P

    Data integrity breakdown with VBA macro adding sheets?

    Hello All, I have a VBA macro that takes subsequent data sets, runs each through an algorithm, takes a screen print of the result and pastes to each newly created sheet. The issue I’m trying to get my head around is that after Sheet197 is created as it should be, Sheet198 is a repeat of the...

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