![]() |
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]() |
![]() |
|
![]() |
||||
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 |
![]() |
Grasshopper | Excel | 3 | 02-14-2013 01:41 AM |
![]() |
coxjamd | Excel Programming | 2 | 01-17-2013 02:24 PM |
![]() |
karti | Word | 2 | 03-15-2011 06:06 AM |