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

and

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

any other ideas?

--
lcorey
-----------------------------------------------------------------------
lcoreyl's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=26232

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