AutoFilter Macro

G

Guest

Is it possible to set Criteria1 to > or Equal To "s" ? I tried but could not
get it to work. Thank you in advance.

Dim s as String
s="=" & Range("A2").Value
Selection.AutoFilter Field:=23, Criteria1:= s, Operator:=xlAnd
 

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

Macro Problem 1
Macro Question 1
Using a macro to control the autofilter function 2
Excel Macro to use cells as a autofilter 0
Autofilter using cell reference 2
Macro Prob 3
Macro for autofilter using variables declared in worksheet 2
Change criteria in a CF 5

Top