Reapply filter

  • Thread starter Thread starter Choose Top 3 Automatically
  • Start date Start date
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---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to ask an autofilter what is current filtered criteriais? 1
Filter & sort 6
Can I move a button from toolbar to a worksheet? 1
Programatically Filter a protected shared worksheet 1
Autofilter - Remember settings 2
Storing Formats of cells in Array and reapply later 3
auto-protect a sheet upon workbook close 4
How do I reapply a Notes template in PPT 2007? 1

Back
Top