A
alistair01
Whenever i run this piece of code i get the error
"paste method of worksheet class failed" runtime error 1004
This is in excel 2003 and i did not have this problem in 2000. Coul
anyone shed any light on this??
Range("A1").Select
Sheets("atl").Select
Range("A1").Select
Selection.AutoFilter Field:=9
Selection.AutoFilter Field:=8
Selection.AutoFilter Field:=11
Selection.AutoFilter Field:=9, Criteria1:="1"
Selection.AutoFilter Field:=13, Criteria1:="3"
Columns("J:J").Select
Range("J:J,B:B").Select
Selection.Copy
Sheets("Alarm Type-Door").Activate
Range("a1").Select
ActiveSheet.Paste
Columns("A:A").EntireColumn.AutoFit
Columns("B:B").EntireColumn.AutoFit
Range("A1").Select
When i enter the vb editor the line activesheet.paste is highlighte
which i presume is where the error is
"paste method of worksheet class failed" runtime error 1004
This is in excel 2003 and i did not have this problem in 2000. Coul
anyone shed any light on this??
Range("A1").Select
Sheets("atl").Select
Range("A1").Select
Selection.AutoFilter Field:=9
Selection.AutoFilter Field:=8
Selection.AutoFilter Field:=11
Selection.AutoFilter Field:=9, Criteria1:="1"
Selection.AutoFilter Field:=13, Criteria1:="3"
Columns("J:J").Select
Range("J:J,B:B").Select
Selection.Copy
Sheets("Alarm Type-Door").Activate
Range("a1").Select
ActiveSheet.Paste
Columns("A:A").EntireColumn.AutoFit
Columns("B:B").EntireColumn.AutoFit
Range("A1").Select
When i enter the vb editor the line activesheet.paste is highlighte
which i presume is where the error is