Very simple VBA question

[bienvenu]

Hello

I don't do VBA, but I do record macros and I have done this one which clears the filters on a sheet and then navigates to another sheet.

It works fine, unless there are no filters to clear on the sheet, in which case I get an error

Sub resetfilterstest()
'
' resetfilterstest Macro
'


'
ActiveSheet.ShowAllData
Sheets("FrontEnd").Select
End Sub

 

[NeonRedSharpie]

[COLOR=#333333]Sub resetfilterstest()[/COLOR]
[COLOR=#333333]'[/COLOR]
[COLOR=#333333]' resetfilterstest Macro[/COLOR]
[COLOR=#333333]'[/COLOR]


[COLOR=#333333]'
On Error GoTo skipTheFilter
[/COLOR]
[COLOR=#333333]ActiveSheet.ShowAllData

[/COLOR]skipTheFilter:
[COLOR=#333333]Sheets("FrontEnd").Select[/COLOR]
[COLOR=#333333]End Sub[/COLOR]