How to undo autofilters without removing?
 

Greetings! Would like to undo all autofilter selections (would be
equivalent of selecting All in each one) in the active workbook without
removing the autofilters. Is there a VBA function or procedural sequence to
accomplish this?

Thanks,
George

How to undo autofilters without removing?
 

Hi George,

Try:

'=============
Public Sub Tester()
ActiveSheet.ShowAllData
End Sub
'<<=============


---
Regards,
Norman


"G Lykos" wrote in message
...
Greetings! Would like to undo all autofilter selections (would be
equivalent of selecting All in each one) in the active workbook without
removing the autofilters. Is there a VBA function or procedural sequence
to
accomplish this?

Thanks,
George