| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
renaming sheets
Helpful as always.
Thanks, wal50 "Ron de Bruin" wrote: Hi Kjeldc Try this ActiveSheet.Name = ActiveSheet.Name & " " & Year(Date) - 1 -- Regards Ron de Bruin http://www.rondebruin.nl "Kjeldc" wrote in message ... How do I rename a worksheet like this: Original name + (Year-1) I want to save some worksheets when a new year starts and use the old name again on a new empty sheet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Renaming Sheets | Excel Discussion (Misc queries) | |||
| renaming sheets dinamically | Excel Programming | |||
| Renaming sheets | Excel Programming | |||
| Renaming Sheets in a workbook | Excel Programming | |||
| renaming sheets | Excel Programming | |||
Threaded Mode
