Bruce,

Look at the filters collection, autofilter object. Something like

MsgBox ActiveSheet.AutoFilter.Filters(2).Criteria1

This will return the criteria of a filter applied to the second field of the
autofilter.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"BruceJ" wrote in message
news:kNglb.846561$uu5.150164@sccrnsc04...
If I have my speadsheet filtered (several differernt filters applied, or
some other complex filter) and I need to jump out of filtered mode, is the
a
way I can "save" the filter to something like a varible or something,
unfilter, do what I need to, and then reset the filter to what it was?
these
are not filters I would ness want to save to a macro, as they might be
unique for a given task, but I would like to reset the filter to what I
had
before so that I could finish processing what I was doing....

TIA
Bruce