Excel runtime error trying to add new rows to a table

[jthomp6395]

Excel novice here again - old dog new tricks. I've been working on some data entry userforms in my workbook, and an encountering a runtime error whenever I try to add new blank rows to an existing named table. The runtime error code is -2147417848 (80010108) "Method 'Add' of object 'ListRows' failed. The table is not protected, the cells are not protected, the table only has 16 existing rows. I've tried reconstructing the code from scratch and splitting the code up to separate subroutines to first add the empty rows, then add data to the rows. Can anyone decipher why this happens? I really need to solve this so I can complete the rest of my work. Here's the code:

Please Login or Register  to view this content.

Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer

[mgs73]

Can you upload the spreadsheet? If I create a table and do ListRow.Add the way you did I don't get any errors.

[romperstomper]

The table is not protected, the cells are not protected

Is the worksheet protected though? If so, you can't add rows to the table.

[jthomp6395]

The worksheet is not protected either. I checked through all that. I suspect that a different subroutine is causing the conflict, but I don't know which or why.

I've attached the file - it's a program to make data entry for energy code evaluation for buildings easier. It has three userforms - frmWall, frmOpen, and frmTB. Module 1 code relates mostly to frmWall, module 2 code to frmOpen, and module 3 code to frmTB.

frmTB is the one I've found causing the runtime error, but I think frmOpen is experiencing the same.

I know my code will be clunky and have faults - I'm an architect (not software) and this is my first time trying to write extensive code. I was starting to go through it to fix known mistakes when it started crashing my Excel.

[Artik]

Investigate whether the cause of the problems is the use of the RowSource property for the ListBox control. Instead of:

Please Login or Register  to view this content.

you can use

Please Login or Register  to view this content.

You lose, admittedly, the ability to use table column headers, but the problem can be easily solved by adding labels over the LisBox control.
If I hit it, it's a known bug in Excel.
The problem can be circumvented by still using RowSource, but before expanding the table, you must first destroy the link to the table

Please Login or Register  to view this content.

then add a row and rebuild the link, but already to the new range.

Artik