| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Parent worksheet.name?
I know how to rename a worksheet in VBA, ***Sheets(i).Name = "Sheet" & i"***,
but I can not seem to rename the parent name. Using ***Sheets(i).Parent.Name*** errors out. (invalid assignment?) If I create a worksheet it counts and adds to the parent name so I could end up with Sheet15(Sheet2) what I want is Sheet2(Sheet2). Thank you in advance. -- Regards Rick XP Pro Office 2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating child worksheet from parent | Excel Worksheet Functions | |||
| Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
| why can't I rename my worksheet? | Excel Discussion (Misc queries) | |||
| rename worksheet | Excel Discussion (Misc queries) | |||
| Detect macro's parent workbook or worksheet | Excel Programming | |||
Threaded Mode
