Confused,

If ActiveSheet.FilterMode Then

Note that ActiveSheet.FilterMode is only True if the Filters have been
applied and are actually hiding some values in the table.

HTH,
Bernie
MS Excel MVP

"Confused Individual" wrote in message
...
How could I express a statement like;
If autofilter=on then...?

what is the value for autofilter?