It is unclear who you are responding to, but if you are responding to me, I
used neither of those constructs. The code I posted will work.



--
Regards,
Tom Ogilvy

"lcoreyl" wrote in message
...

Actually these didn't work.
autofilter.on gives an "object doesn't support this property or
method"

and

activesheet.autofiltermode is seen as true whether or not it is
currently filtering...

any other ideas??


--
lcoreyl
------------------------------------------------------------------------
lcoreyl's Profile:
http://www.excelforum.com/member.php...fo&userid=2042
View this thread: http://www.excelforum.com/showthread...hreadid=262326