-
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
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...