I have Excel 2010 vba code that creates ListObject with ListObject.Add(xlSrcRange, ...) and then fills data from vba recordset.
The problem is:
1. After creating ListObject AUTOFILTER appears in the heading row. How can I disable it.
2. After creating ListObject default column names appears as Column1, Column2, ... but problem is that it CHANGES my column width. Is it possible to "freeze" somehow column width so creating ListObject do not affect them.
3. How can I give the STYLE NAME (one from available in Excel) to ListObject
4. And finally how can I DELETE ListObject