How to write if condition for AutoFilter to check ..?

LearnerExcel · #1 05-05-2018, 04:00 AM

I am getting the following error while executing a Macro when the filter is not applied. But working quite nice when the filter is already applied. How can I write an if condition to check first whether the filter is applied or not, if applied then need to execute this macro else quit.

Error:
Run-time error '1004':
ShowAllData method of Worksheet class failed

Code:

Code:

Sub RemoveFilter()
ActiveSheet.ShowAllData
End Sub

NoSparks · #2 05-05-2018, 08:53 AM

https://msdn.microsoft.com/en-us/vba...property-excel

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I write if condition to get the values ...	LearnerExcel	Excel	3	12-15-2016 03:10 AM
write need help and copy write need help on another page auto	wykoems	Word	2	07-25-2013 07:56 AM
Sum on AutoFilter	Grasshopper	Excel	3	02-14-2013 01:41 AM
AutoFilter Criteria3	coxjamd	Excel Programming	2	01-17-2013 02:24 PM
check with condition	karti	Word	2	03-15-2011 06:06 AM