Posted by Brad on October 15, 2001 2:18 PM
I have a worksheet that I am trying to set to turn the AUTOFILTER on in CODE. So far I have:
for X = 1 to 7
I = I +1
which works fine....EXCEPT.
It barfs when I have mixed sheets with Autofilter onoff in the workbook. Is there a way to check for IF on then ok ELSE AutoFilter = True end if? And set ALL of them ON or OFF accordingly?
(this if...then doesn't work.)
Any suggestions appreciated...TIA