Autofilter Confusion

[Merf]

I'm trying to understand filtering via VBA. Apparently there can be only one Autofilter object per worksheet, since (a) there is no Autofilters collection, and (b) you can't manually filter more than one table at a time on a worksheet. So here's what may be a stupid question:

What's the difference between Worksheet.FilterMode and Worksheet.Autofilter.FilterMode? Are these the same thing?

Likewise, what's the difference between Worksheet.ShowAllData and Worksheet.Autofilter.ShowAllData? Are these identical? When should I use one versus the other?

[LJMetzger]

What's the difference between Worksheet.FilterMode and Worksheet.Autofilter.FilterMode?

As far as I can tell they work exactly the same.

Likewise, what's the difference between Worksheet.ShowAllData and Worksheet.Autofilter.ShowAllData?

As far as I can tell they work exactly the same.

-------------------------------
The above answers were from testing a Sheet that contained 'AutoFilter'.

The syntax in Microsoft documentation I have seen is the shorter syntax, which is probably the Microsoft 'approved syntax'. The other syntax which currently works may stop working in a future version of Excel.

Please Login or Register  to view this content.

Lewis