What's filtered in the table?

[Jaymond Flurrie]

Can I somehow get a list by VBA of how/what my table is filtered? The idea is that user might filter something, then use my "add record"-button and it results as "Cannot shift cells in filitered cells or table". Now the way to get rid of this error is to clear filters, but can I take this a bit forward by re-applying the filter so how do I read/write the filtering there?

 

[ukmikeb]

Hi

In VBA -

ActiveSheet.Autofilter.Range.Address

gives you the "selected" range that has been filtered.

hth

 

[Jaymond Flurrie]

Hi

In VBA -

ActiveSheet.Autofilter.Range.Address

gives you the "selected" range that has been filtered.

hth

Thanks!