add sheet

  1. T

    New Sheet with automatic naming & easy file navigation

    Hi all, I would like to have an excel file where I can easily navigate through the sheets. I have sheets for each week, but when I need an extra week, I would like to add a next sheet with one click. A macro is required for that. When that macro adds a new sheet, I would like the macro to...
  2. V

    'Name' of object '_VBComponent' failed

    Trying to use sheet code names instead of sheet names, in case users change the sheet name, and the below returns the error "'Name' of object '_VBComponent' failed". Test2.Delete Worksheets.Add ws_name = ActiveSheet.Name...
  3. N

    Macro to Add New Sheet with a New Year in every Sheet

    Hey guys, I am new to VBA and I am climbing the ladder by working on simple projects. Currently I am working on a calendar, it has a button "Add New Cal", when clicked it duplicates the active sheet but only changes the year; i.e. The active sheet has a calendar year 2016 and is a named range...
  4. J

    Macro Add Sheet Problems

    Microsoft Excel 2007 Windows XP My code works fine for creating the first 10 sheets but then stops. I'm not sure if that means I am copy-pasting too much for the document to handle or what. In module1: Private Sub Button1_click() Call Device1 Call Device2 Call Device3 Call Device4 Call...
  5. M

    Problem Implementing ActiveCell.FormulaR1C1 in VBA (with string)

    Good Morning, I've done all kinds of searching, around this message board and other places, and I cannot figure out why I am getting an error here: ActiveCell.FormulaR1C1 = "=(IF(ISERROR(VLOOKUP($B6," & Qtwo & "$C$2:$BE$92,54,FALSE)),""No Data"",VLOOKUP($B6," & Qtwo &...
  6. G

    VBA to insert and name sheet but avoid duplicate sheet name

    Dear All, I have VBA to add a new sheet. ActiveSheet.Copy Before:=Sheets(1) ActiveSheet.NAME = "Entry" However, I get an error if that sheet name already exits. How can I insert a new sheet and name it without creating a duplicate? Concatenating a sequence number to the end of...
  7. B

    Adding sheets from a list

    Hello All, I have a macro which creates worksheets based on a list in a specific sheet that I called Tools. The macro looks at this list and creates sheets which are named according to the list. What I need to accomplish now, is to have additional sheets created if and when I need to update or...
  8. H

    Code to always add new sheet after the last sheet

    Hi, i need some clue to do the following: whenever the macro is run, it will add a new worksheet as the last sheet, nomatter how many existing worksheets there are (i.e. the right most sheet tab will be this new added sheet) Sub AddLastSheet() Dim ws as Worksheet Set ws = worlsheets.Add...

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