sheet rename

  1. D

    Macro Run-time error '9' when I changed sheet names

    I had my macro working and then I change my sheet names and its giving me a Run-time error '9'. I know it has something to do with the name change but I can not figure out how to make the macro only look for the codename not the sheet name. Any help would be greatly appreciated. Here is my...
  2. N

    VBA code - Rename a tab/sheet automatically when updating A1 that contains a formula

    Hi, i am working on office 2007 with Windows XP. i have the following code already available: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) 'one cell at a time If Target.Cells.Count > 1 Then Exit Sub If Intersect(Target, Sh.Range("A1")) Is Nothing Then Exit Sub...
  3. H

    Naming the Sheet after the date

    Hi, I am using Excel 2007 and hope to create a simple macro that changes the Sheet Name to the date. But I want the date to exclude the year for the sake of space, or in a format similar to "MM-DD". ie. If the macro ran today, the sheet name would change to "11-09". Been trying a line of...

Some videos you may like

This Week's Hot Topics