Add a Column to a Table

To add a column to an Excel table use ListColumns.Add and specify the position of the new column.

 

70+ MUST KNOW EXCEL SHORTCUT KEYS: Download the pdf from our Excel training page
UNDERSTAND & FIX EXCEL ERRORS: Download the pdf from our Excel training page
Learn how to fix these errors: #DIV/0!, #N/A!, #NAME?, #NULL!, #NUM!, #REF! & #VALUE!

Add a Row to a Table

To add a row to an Excel table use ListRows.Add and specify the position of the new row.

Add Row and Enter Data

Add/Overwrite Data in a Specific Record

Delete Row or Column

Established in 2005, Blue Pecan provides in house Excel training courses at your business premises. We offer BeginnersIntermediate and Advanced Excel training as well as Excel Dashboards, Power Query, Power Pivot and Macros/VBA courses. 

Posted by Chester Tugwell