yoinkster
10-28-2008, 04:26 AM
Hey guys,
I have a macro that filters on different columns depending on what option is selected on a userform. This works fine when the filtering is already switched on on the worksheet but falls over when there is none.
Is there a way of saying like
If autofiltering is off then
switch it on
I have a macro that filters on different columns depending on what option is selected on a userform. This works fine when the filtering is already switched on on the worksheet but falls over when there is none.
Is there a way of saying like
If autofiltering is off then
switch it on