Tabellab
Intermediate

Excel Tables (ListObjects)

Stop guessing where your data ends — drive real Excel Tables from VBA and let them resize themselves.

7 lessons 58 min Certificate

The first lesson is free — no account needed.

About this course

Stop guessing where your data ends. You learn the VBA ListObject object model, convert a range into an Excel Table, add and remove rows, use structured references in code, read and write table data fast, and filter and sort a table from VBA.

Lessons

  1. Why Tables Beat Plain RangesReading11 minFree
  2. The ListObject Object ModelReading8 min Pro
  3. Converting a Range into a TableReading7 min Pro
  4. Adding and Removing RowsReading8 min Pro
  5. Structured References in VBAReading8 min Pro
  6. Reading and Writing Table Data FastReading8 min Pro
  7. Filtering and Sorting a TableReading8 min Pro