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!

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!



.

You use Autofiltermode as Chip suggested, but you test if it is applied, and
if so, clear it, then reapply it.

Why not just use showall if it is applied and continue from there, else
apply it.

Regards,
Tom Ogilvy




kayla711 wrote in message
...
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!



.