Difference between 2 VBA codes to clear filters

[willow1985]

Hello,

I was wanting to know what the difference was between these 2 codes to clear filters? I was given these in the past and was wondering if there was a difference?

Sometimes I want to clear a filter on a table and other times just a standard filter.

Thank you for your help ?

'Code #1'
If (ActiveSheet.AutoFilterMode And ActiveSheet.FilterMode) Or ActiveSheet.FilterMode Then
  ActiveSheet.ShowAllData
End If

'Code #2'
         Dim lo As ListObject
  For Each lo In ActiveSheet.ListObjects
    lo.AutoFilter.ShowAllData
      Next lo

 

[JLGWhiz]

The second one is specifically for a filter used in a named table or list. The first one is for a general worksheet.

 

[willow1985]

Thank you very much for the info ?

 

[JLGWhiz]

Thank you very much for the info ?

You're welcome,
regards, JLG