name 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. B

    Name a sheet from a cell, with error checking

    I am trying to get my sheets to name themselves from a cell within the sheet. I have tried several codes found on this and other forums but the best I have managed is to get it to do it once then come up with errors when it works with a macro I made to add data from another sheet and create a...
  3. N

    Excel Worksheet Tab Name Vs. VBA Worksheet Name

    Hello, I have changed the "Tab Name" of my worksheet to "Instructions" but in the VB editor the worksheet is referred to as "Sheet3 (Instructions)". I cannot find out how to change the name in the VB editor from "Sheet3" to "Instructions". I'm surprised how frustrated this has made me. Must I...
    • nryan
    • Thread
    • name sheet name worksheet sheet name worksheet name vba
    • Replies: 4
    • Forum: Excel Questions
  4. S

    create new sheet based on date and paste rows from other sheet with x in column A.

    I am trying to write a macro that once the warehouse guy is done for the day can create a new sheet titled 'the current date' totals, then export all rows that have x in column A from a sheet called 'the current date' to this new sheet. I have the template done for him and a macro that creates...
  5. 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...
  6. B

    Macro: Dynamic creation of sheet based on cell value then copy range to the new sheet

    I've created a workbook which tracks stats for my local pool league. There are team, partner sets and player stats collected per week. I also want to track player stats on a per game basis and this is the reason for the post. I've run into a problem in that I can't copy the range of collected...
  7. 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...

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