Reapply filter

[Choose Top 3 Automatically]

Is there a way to reapply a filter automatically?

 

[ryguy7272]

See this example:
http://www.rondebruin.nl/copy5.htm#Add

I think you need something such as:
'Filter the range
rng.AutoFilter Field:=FieldNum, Criteria1:="=" & cell.Value
'etc., etc., etc., etc., etc.,
'Close AutoFilter
ws1.AutoFilterMode = False

Experiment with the macro recorder too!!


Regards,
Ryan---