Hi,
I use Excel 2007 and I have a spreadsheet with data in column a thru O and 300 rows with Autofilter turned on for all columns and buttons with code behind them.
I'm trying to capture the state of Autofilter to be able to revert back to it. In more details here is what I do: I use...