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---

--
RyGuy


"Choose Top 3 Automatically" wrote:

Is there a way to reapply a filter automatically?