I like the functionality of tables (ListObjects) but haven't found much documentation to unlock the power of them in VBA. I declare each table as a ListObject but can't figure out how to use the [[]:[]] technique, so I resort to hardcoding column offests.
The issue at hand is I need to clear the filters (not turn filtering off) in all my tables before running the macro. I tried to use WorkSheets(index).ShowAllData, but it doesn't work.
Since the WorskSheet method doesn't work, do I need to use a ListObjects method clear the filters? If so I can't find it.
Thanks
The issue at hand is I need to clear the filters (not turn filtering off) in all my tables before running the macro. I tried to use WorkSheets(index).ShowAllData, but it doesn't work.
Since the WorskSheet method doesn't work, do I need to use a ListObjects method clear the filters? If so I can't find it.
Thanks