View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bwilk77 bwilk77 is offline
external usenet poster
 
Posts: 15
Default Paste method error in macro

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