Quick question

  • Thread starter Thread starter DB100
  • Start date Start date
D

DB100

Hi Guys

Can anyone tell what the additional code would be to set this aut
filter to a cell reference. So that when the Macro runs it filters th
contents of the Cell A1 for example

Thanks

Selection.AutoFilter


Selection.AutoFilter Field:=1, Criteria1:="a2"

Selection.AutoFilter Field:=19, Criteria1:="a1"

Thank
 
Selection.AutoFilter Field:=19, Criteria1:=Range("A1").Value
 
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

Selection.AutoFilter Issue 1
Help me4 2
Multiple Filter Criteria in Excel VBA 4
can anybody speed up this macro 2
Apply macro to all worksheets 15
Error Handle problem 4
Looping through visible cells 10
AutoFilter Criteria in VBA 13

Back
Top