Data Filtering 'Show All' macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2000, I have created a macro that has the same functionality as
the data toolbar command 'Show All' and assigned it to a command button on
the worksheet. How do I modify the macro so that it recognises that the data
is unfiltered and prevents a run-time error '1004'message appearing?

Regards

Andy
 
Sub AA()
If ActiveSheet.FilterMode Then
ActiveSheet.ShowAllData
End If
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing filters from data 1
Locking cells in Auto filtered list 3
Macro execution changes filename reference for all macros 1
Advanced Filter Error 1004 2
Macro Breaks When criteria is deleted 3
AutoFilter can't work after the worksheet is being protected!!! 7
Stop Command Question 4
remove autofilter results with a macro 2

Back
Top