| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste method of worksheet class failed error
1. Your Paste code line is not as explicit as that required. We should
evidently, use something like :- '----------------------------------------------------------------------------- ActiveSheet.Paste Destination:=Worksheets(1).Range("C5") '----------------------------------------------------------------------------- Seems like a "belt and braces" approach - but it is probably " feature, not a bug". Despite this, I do get inexplicable problems wit Paste at times. Generally find that the following produces bette results than using Select or Activate:- '---------------------------------------------------------------------------- Application.Goto reference:=wb.Worksheets(1).Range("C5") '---------------------------------------------------------------------------- -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
| Error 1004 Copy method of worksheet class failed | Excel Discussion (Misc queries) | |||
| Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
| error 1004 Select method of Range class failed | Excel Programming | |||
| Error Excel: 1004 SaveAs method of Workbook class failed | Excel Programming | |||
Hybrid Mode
