menken.john wrote:

Hi, I'm using Excel 2010 on Windows 7 and I have created a loop that
goes through each worksheet in the workbook and performs several routine
operations. For some strange reason it ignores my line about turning off
the autofilter. When I run the macro it resets the cursor to A1 and
eliminates any marching ants but the AutoFilter on several sheets
remains 'on.' Can anyone tell me what I might be doing wrong? I've
included the code below. Many thanks.
[snip]

Just a thought, don't check ActiveSheet.AutoFilterMode, just set it = False.

--
It's like God is pointing at me saying,
"THOU SHALT NOT GET ANY TONIGHT THOU WANTON WENCH!"
**** you, God... **** you.