milesUK
Active Member
- Joined
- Jan 5, 2003
- Messages
- 388
I have used some VBA code to set the Autofilter on in Excel. The AutoFilter works fine the first time the code is run but if the code is run again even though the filter buttons appear they will not 'press' (and all the filter buttons show black down-arrows on grey backgrounds with no filtering actually applied) and the filter cannot be used. :x
Data-->Filter-->AutoFilter turns it off OK but I can not get VBA to ensure the filter is off before applying it. please.
Miles
Data-->Filter-->AutoFilter turns it off OK but I can not get VBA to ensure the filter is off before applying it. please.
Miles