AUTOFILTER problem1
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:
I=7
for X = 1 to 7
sheet(I).select
With Selection
.AutoFilter.Range ("A1")
end with
I = I +1
next X
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
Brad