Test the AutoFilterMode property of the Worksheet. E.g.,

If Worksheets(1).AutoFilterMode = True Then
' whatever


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"kayla711" wrote in message
...
Hello all,

I've created a spreadsheet that basically opens up another
workbook, filters two columns using AutoFilter, selects
several columns of the filtered data, and then pastes it
in the original spreadsheet. This works fabulously, no
problems here.

My question is this: how can I have Excel test to see if
AutoFilter is on or off? What I need it to do is test to
see if AutoFilter's on, and if it is, go on with the
macro, and if it's not, turn it on, then go on with the
macro. Anyone know?

btw, Office 97 on win2k

TIA!