|
test for autofilter
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! |
test for autofilter
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! . |
test for autofilter
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! . |
| All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com