Autofilter choice
Posted by amroo on May 14, 2001 12:40 AM
Bonjour, I want to know if it's possible to put an autofilter on specific columns; Exple: C and F
The code below put autofilter on each columns C, D, E, F, or I just want it on C and F.
Here the code for selecting blank cells.
+++++++++++++++++++++++++++++++++++++++++++++++++
ActiveSheet.AutoFilterMode = False
Range("C4:F4").AutoFilter
Range("C4:F4").AutoFilter Field:=1, Criteria1:="="
Range("C4:F4").AutoFilter Field:=4, Criteria1:="="
++++++++++++++++++++++++++++++++++++++++++++++++++++
Thanks for suggestions.
A+mroo