| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy sheet problem
Hello,
I've got the run-time error "Copy method of worksheet class failed" and is trying to use the MSDN workaround for this problem(se http://support.microsoft.com/default...4&Product=xlw). But in the MSDN workaround they only copy cells, I want to cop everything in the sheet, format also. Sheets.Add Befo=Sheets(1) Sheets("Mysheet").Cells.Copy Sheets(ActiveSheet.Name).Paste How to copy everything in the sheet? Thank you. Siri -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| For Tom Ogilvy re Copy Sheet Problem | Excel Programming | |||
| Copy Sheet Problem | Excel Programming | |||
Threaded Mode
