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