Adding Excel Tables using VBA - and stepping through Table parts

Learn how to convert an existing range into an Excel Table using VBA. And find out about Table anatomy.

In this 14 minute video we cover:

• Converting a data set of 100 student test scores from an ordinary Excel range into an Excel Table
• Why Tables are called ListObjects in the Excel Object model (and not Tables)
• How to call different parts of a Table
  • Whole Table Range
  • Header Row Range
  • Data Body Range
  • Totals Row Range
  • ListColumn(N)
  • ListRow(N)
• A simple explanation of Error Handling (On Error Goto Err_Handler)
• Converting an Excel Table back to ordinary range using the VBA method ".unlist"

Note: you can download and play with the sample data set in the Project Workbook Download

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]