Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting a copied worksheet
Hello,
This works for me: Set MyWorksheet = Worksheets.Add This doesn't: Set MyWorksheet = Worksheets("Sheet1").Copy Is there a way to do the set and copy on one line or do I copy and then set on the next line? Thanks, Doug Glancy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can data be copied from one worksheet to another? | Excel Worksheet Functions | |||
how do i restore a copied over worksheet | Excel Worksheet Functions | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
Get the name of a newly copied worksheet | Excel Programming | |||
How name a copied worksheet? | Excel Programming |