Quote:
> Can anyone help me out with this. I was wondering if
> there is a way to turn on the autofilter and do a custom
> filter on a column using VBA. I ran a macro to see if it
> would follow but the macro automatically stops when I
> click custome (after pulling down the filter). Any help
> would be greatly appreciated.
> Thank
Forget about autofilter and simply record a macro of you creating a regular
filter with the criteria you want.
It will give you the same filtering results.
--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project
-Jack Dahlgren, Project MVP
+++++++++++++++++++
Custom AutoFilter in VBA