Hi,

I am trying to filter reason for "SHO" and then copy and paste this to a new tab. I have the following code

ActiveSheet.Range("$A:$V").AutoFilter Field:=3, Criteria1:="SHO"
Cells.Copy
Sheets("SHO").Paste
Sheets("Input").Select
Selection.AutoFilter
Columns("E:G").Select
The error i receive is "the copy and paste area are not the same size" so i tried selecting a specific cell and it still has the same error
Any help would be appreciated

Thanks