When I run the following instruction, I got the error
"Autofilter method of Range class failed"
Selection.AutoFill Destination:=Range("G10:G" & lastrowx), Type:=xlFillDefault
Range("G10:G35".Select
Columns("L:L".Select
Selection.Delete Shift:=xlToLeft
Rows("8:8".Select
Selection.Delete Shift:=xlUp
Rows("1:5".Select
Selection.Delete Shift:=xlUp
Columns("O:O".Select
Selection.Insert Shift:=xlToRight
' Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="=BUY*", Operator:=xlOr, Criteria2:="=SELL*", VisibleDropDown:=True
Best regards
"Autofilter method of Range class failed"
Selection.AutoFill Destination:=Range("G10:G" & lastrowx), Type:=xlFillDefault
Range("G10:G35".Select
Columns("L:L".Select
Selection.Delete Shift:=xlToLeft
Rows("8:8".Select
Selection.Delete Shift:=xlUp
Rows("1:5".Select
Selection.Delete Shift:=xlUp
Columns("O:O".Select
Selection.Insert Shift:=xlToRight
' Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="=BUY*", Operator:=xlOr, Criteria2:="=SELL*", VisibleDropDown:=True
Best regards