Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename active sheet
I was using a macro in exel 2002, and now have exel 2003.
The coding for changing the name of the active sheet (Which was: Active sheet.Select ; ActiveSheet.Name = "sheet1") does not work with my new exel. Has something changed? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename active sheet
Active sheet.Select
You must use ActiveSheet instead of Active Sheet But if you want to rename the Active sheet then this line is enough ActiveSheet.Name = "sheet1" You can use this to avoid a error if the sheet name already exist On Error Resume Next ActiveSheet.Name = "sheet1" On Error GoTo 0 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Ginny" wrote in message om... I was using a macro in exel 2002, and now have exel 2003. The coding for changing the name of the active sheet (Which was: Active sheet.Select ; ActiveSheet.Name = "sheet1") does not work with my new exel. Has something changed? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename active sheet
all you need is
activesheet.name = "sheet1" exactly as shown -- Don Guillett SalesAid Software "Ginny" wrote in message om... I was using a macro in exel 2002, and now have exel 2003. The coding for changing the name of the active sheet (Which was: Active sheet.Select ; ActiveSheet.Name = "sheet1") does not work with my new exel. Has something changed? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
how do I rename a sheet | New Users to Excel | |||
Rename Active Sheet | Excel Programming |