uktous
06-28-2012, 08:18 AM
Hi,
If we use advanced filter to filter some data, then we can use ActiveSheet.ShowAllData to show all data.
However, if there is no data filtered (ie all data are shown), then using ActiveSheet.ShowAllData will cause error.
In my macro, is it possible to use ActiveSheet.ShowAllData only when some data are filter, and not use ActiveSheet.ShowAllData when all data are shown.
Thanks
If we use advanced filter to filter some data, then we can use ActiveSheet.ShowAllData to show all data.
However, if there is no data filtered (ie all data are shown), then using ActiveSheet.ShowAllData will cause error.
In my macro, is it possible to use ActiveSheet.ShowAllData only when some data are filter, and not use ActiveSheet.ShowAllData when all data are shown.
Thanks