D
Dave
Using VBA i want to make sure Autofilter is off before I run some other code.
I ran macro recorder and see that the command
Autofilter
toggles the autofilter on and off. The problem is I just want to turn it
off, so i can't use this command if the autofilter is not on or it turns it
on.
Is there some resource online or within help that describes the macro
commands and which qualifiers you can use with them (I tried "Autofilter off"
and "Autofilter False", but it gives me errors).
Can anyone tell me how to use this command to switch autofilter off.
Thanks
Dave
I ran macro recorder and see that the command
Autofilter
toggles the autofilter on and off. The problem is I just want to turn it
off, so i can't use this command if the autofilter is not on or it turns it
on.
Is there some resource online or within help that describes the macro
commands and which qualifiers you can use with them (I tried "Autofilter off"
and "Autofilter False", but it gives me errors).
Can anyone tell me how to use this command to switch autofilter off.
Thanks
Dave