Table1[#all] Reference the whole table including headers and totals Table1[] Reference the data part of the table excluding the headers and totals. This is the same as Table1[#Data] Table1[Column1] ...

Attached are new source files, an Excel Macro enabled workbook, an export Excel class file of all the macros in the workbook. Towards the bottom of the macro file (and in the Excel workbook) are some ...