Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying and Renaming New Sheet
Need help in VBA coding to make a copy of a sheet within the same file,
preferably just to the right of the original version, then rename that sheet to include the day of month. For example, I want to take a sheet named Ship Plan, make a copy of that sheet, then rename the new sheet Ship Plan (DD), where DD is the current day of the month. I know it's not tough, but just haven't done this before, so I'm hoping someone can help with the code. Thanks, Todd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Renaming sheets with the same name after copying into a new workbo | Excel Discussion (Misc queries) | |||
Copying and renaming a file | Excel Discussion (Misc queries) | |||
copying and renaming a worksheet | Excel Programming | |||
copying and renaming sheets | Excel Programming | |||
Copying and renaming worksheets | Excel Programming |