I recorded a macro which suppose to unhide all hiden columns, and clear all filters. When i run macro everything is ok, but if i run it again i get message: Run-time error "1004":


ShowAllData method of Worksheet class failed

How to avoid that?

Please post the code you are using. It's impossible to say what the issue is without seeing it.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hope i doing right.
Here is my code

Sub Macro1()
'
' Macro1 Macro
'

'
Cells.Select
Selection.EntireColumn.Hidden = False
ActiveSheet.ShowAllData
Range("C1:E1").Select
End Sub

Try:
PS: As mentioned in my last post, please use the code tags when posting code. They're on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you, thank you,
it works!!!