| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheets.Add using other worksheet as "template"
Hi,
I have a worksheet call MASTER In one of the macro which create new worksheets dynamically, I need to create the new worksheet using the worksheet MASTER. Part of the macro: dim ws_new as worksheet Set ws_new = Sheets.Add Sheets.Add just add empty worksheet, what is the right syntax to the above macro to use the MASTER worksheet? Nic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | Excel Discussion (Misc queries) | |||
| "Count" and "List" functions across sheets | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Template question - can I replace the default "worksheet" template | Excel Discussion (Misc queries) | |||
| How do I set the default to "Open" or "New" for a template | Excel Discussion (Misc queries) | |||
Threaded Mode
