-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
sheet rename
-
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...- Dustin R
- Thread
- Replies: 1
- Forum: Excel Questions
-
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...- NTschanun
- Thread
- Replies: 18
- Forum: Excel Questions
-
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...- hypnoshrew
- Thread
- Replies: 2
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 35
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 36
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...