Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a macro that is trying to copy certain from one sheet and paste it
into a different sheet (both in the same workbook). For the most part this is working, except when it is run on one specific computer, I get the error 1004 "Paste method of worksheet class failed". Why would this only happen on one particular computer? Here is the code that is erroring out. Sheets("x").Select Range("A1").Select Columns("A:A").Select Selection.Delete Shift:=xlToLeft Cells.Select Cells.EntireColumn.AutoFit Selection.AutoFilter Field:=22, Criteria1:="GR" Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets("GR_fast_movers_not_in_talls").Select Range("A1").Select ActiveSheet.Paste Thanks, Brad |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
error running a paste macro | Excel Worksheet Functions | |||
Effective method to paste array formula | Excel Worksheet Functions | |||
Method 'Paste' of object '_Worksheet' failed | Excel Discussion (Misc queries) |