Thanks Chip, but actually found more what I'm looking for
somewhere else...here's what i found FYI...

'Test to see if AutoFilter is on if so turn it off
If ActiveSheet.AutoFilterMode Then
Selection.AutoFilter
End If

'Initiate AutoFilter
Rows("1:1").Select
Selection.AutoFilter


-----Original Message-----
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!



.