-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
field=7
-
J
VBA autofilter field using dynamic range
Hello all, If I have the following line of VBA, can I make the "AutoFilter Field:=7" number dynamic? ActiveSheet.Range("Data_column_headers").AutoFilter Field:=7, Criteria1:="=" Ideally I would place my named range in there as my columns move around. Thanks!- jcooooper
- Thread
- autofilter dynamic field=7 range vba
- Replies: 17
- Forum: Excel Questions
-
B
VBA table filter not working..
Hi This part of my code applies a greater than or equal to filter successfully; If ActiveSheet.Range("G3").Value <> "" Then .AutoFilter Field:=7, Criteria1:=">=" & ActiveSheet.Range("G3").Value End If But I want it to be equal to, but when I change it, it doesn't...- BenGee
- Thread
- .autofilter activesheet.rangeg3.value end field=7 filter
- Replies: 2
- Forum: Excel Questions
-
M
Macro Autofilter by today date?
How to use today formula in below coding to get all the records before today's date? ActiveSheet.Range("$A$2:$M$377").AutoFilter Field:=7, Criteria1:="50" "<29.1.2011", Operator:=xlAnd- meetz
- Thread
- autofilter criteria1= date field=7 today
- Replies: 6
- Forum: Excel Questions
