(Solved) – Add the row below a table to the table range

(solved)-–-add-the-row-below-a-table-to-the-table-range

I am trying to resize a table to include the data in a row directly below the last row in a table. My current code looks like this but returns an object defined error. Also, the table changes location as rows are added both above and below it.

tbl.resize tbl.Range.CurrentRegion.Offset(1, 0)

I have used the following sources to try and resolve this problem with no luck. Resize Listobject Table dynamically with VBA
https://docs.microsoft.com/en-us/office/vba/api/excel.range.resize

Leave a Reply

Your email address will not be published. Required fields are marked *