Search notes:

Excel Object Model: add rows to a ListObject

The following example tries to demonstrate how rows can be added to a `listObject object with Visual Basic for Applications.

option explicit

sub main() ' {

    dim rngHeader as range
    set rngHeader = range(cells(2,2), cells(2,4))
    rngHeader.value = array("col one", "col two", "col three")

    dim table as listObject
    set table = activeSheet.listObjects.add(   _
       sourceType             := xlSrcRange  , _
       source                 := rngHeader   , _
       xlListObjectHasHeaders := xlYes)

    table.listRows.add.range.value = array("foo", 42, #2020-03-05#)
    table.listRows.add.range.value = array("bar", 99, #2017-10-17#)
    table.listRows.add.range.value = array("baz",  5, #2018-03-21#)

end sub ' }

Github repository about-MS-Office-object-model, path: /Excel/ListObject/add-rows.bas

After running this simple program, the following list table is produced:

Index