Problem with macro

MS baby · #1 03-29-2014, 11:55 AM

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?

macropod · #2 03-29-2014, 01:57 PM

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.

MS baby · #3 03-30-2014, 07:57 AM

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

macropod · #4 03-30-2014, 10:17 AM

Try:

Code:

Sub Demo()
On Error Resume Next
ActiveWorkbook.ActiveSheet.ShowAllData = True
End Sub

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

MS baby · #5 03-31-2014, 02:47 PM

Thank you, thank you,
it works!!!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Problem with macro	tmill29	Excel Programming	1	06-08-2013 09:59 AM
Moving data macro problem	MattMurdock	Excel Programming	1	07-20-2012 04:49 AM
Another simple macro problem	Ulodesk	Word VBA	1	06-08-2012 06:24 PM
Interesting hyperlink macro problem	DobberHockey	Word VBA	7	03-26-2012 09:26 PM
Problem with AutoClose macro and Word 2003	cholo	Word VBA	0	07-08-2009 05:48 AM