looking for autofilter with code
 

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

looking for autofilter with code
 

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