rename worksheets

  1. O

    Rename Worksheets Using "Master" Worksheet

    Hello, I need to change the name of the spreadsheets in the Workbook using a "Master" list created in the same Workbook. I tried to use the VBA below but got a 400 error code. I appreciate any assistance...I feel it is something simple I just cannot figure it out. I was going to attach the...
  2. Q

    rename worksheets based on list

    Hello everyone, I have a bunch of worksheets as from sheet2 to sheet35. I need to rename them based on a list in sheet1 named "List" starting from cell A2. I've already found this, but it doens't work: Sub rename() Dim lr As Long lr = Sheets("List").Cells(Rows.Count, 1).End(xlUp).Row...
  3. T

    Run-time error when using VBA to rename worksheets

    Please help!!! Firstly, I am a VBA beginner. I have a Excel (2010) workbook where there are many sheets that need to be renamed according to a list of names on the first sheet named "Testing". The range of names (starting at cell A3) on the first sheet are a part of a Pivot Table. When the...
  4. J

    rename sheets

    I have three worksbooks with 50+ sheets in each one. The first worksheet in each workbook contains a list of accounts with a balance next to it. the other sheets in the books contain the detail for each account that make up that balance. The detail sheets have generic names attached to each...
  5. K

    Copying Worksheet 20 times then Rename each Worksheet

    Hello! :confused: I am trying to copy a worksheet about 20 times and then I need to rename each worksheet by a string name. For Example: ActiveSheet.Name = "VOTD Non-EXW" ActiveSheet.Name = "VOTD Non-Pharma" ActiveSheet.Name = "VOTD Pharma" I found the...
  6. C

    Sort, copy, rename, save worksheets

    I'm very in experienced at codes, please help...(excel2007) I have a work sheet (sheet1) with header rows 1-3. Data rows start at 4 though to up to 500. This has columns A-I. I have 12 brokers that submit deals for approval contained in sheet1, hence these 12 names come up as the deals get...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top