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"
Columns("L:L"
Selection.Delete Shift:=xlToLeft
Rows("8:8"
Selection.Delete Shift:=xlUp
Rows("1:5"
Selection.Delete Shift:=xlUp
Columns("O:O"
Selection.Insert Shift:=xlToRight
' Selection.AutoFilter
Selection.AutoFilter Field:=3, Criteria1:="=BUY*", Operator:=xlOr, Criteria2:="=SELL*", VisibleDropDown:=True
Best regards