| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create new sheet with a macro
I have a sheet named "Sep 07".
How can I create a new sheet, automatically named "Oct 07", and copy formatting (but not data) as well as vba code and buttons from "Sep 07" (Range A1:M25) by using a macro? Obviously, at the end of October, the new sheet will need to be called "Nov 07" and so on. How would I deal with that? Thanks, -- Traa Dy Liooar Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to create new sheet | Excel Discussion (Misc queries) | |||
| macro to create, name sheet and copy. | Excel Discussion (Misc queries) | |||
| Macro to Create Sheet & Duplicate Sheet | Excel Programming | |||
| How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming | |||
| Do you know how to create a new sheet in a file by macro? | Excel Programming | |||
Threaded Mode
