View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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