ExcelBanter - filtering (all) by value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filtering (all) by value (https://www.excelbanter.com/excel-discussion-misc-queries/195234-filtering-all-value.html)

Nader

filtering (all) by value

dear Gary
all dears
I applied your macro and it work well:
Selection.AutoFilter Field:=6, _
Criteria1:="=" & Range("Sheet2!A1").Value, _
Operator:=xlAnd, _
Criteria2:="<=" & Range("Sheet2!A2").Value

I realy appreciate your help. Now I need to filter (all) by putting a value
in specified cell.
thanks

All times are GMT +1. The time now is 12:07 AM.