In this post we see how to convert a range with data into a table with Excel VBA macros. They are different VBA objects altogether – Range vs ListObject. Tables are a most efficient way to organize the raw data and refer to dynamic data that can expand across rows or columns. Tables can also be easily styled. The macro example below removes any previous table with a given name, converts a range with data into a table, and applies a specific style.
Slicers are a cool feature initially used only with pivots that Microsoft Excel 2013 and following versions made available for data tables too. In this post we see how to add slicers in Excel using VBA macros. More specifically, the macro code below adds the slicers on top of table headers to allow filtering the table using the slicer instead of the drop-down filter option. It adds as many slicers as columns in the Excel data set that we want to filter.
