Adding blank row to table

Hi guys,

I’ve got an excel spreadsheet that has two tables one above the other with a few blank rows between.

I then have a button which should add a row at the bottom of the top table. However it comes up with an error message.

“Run time error ‘1004’ This won’t work because it would move cells in a table on your worksheet.”

This is the code.

Please Login or Register  to view this content.

I’m assuming it’s because it’s moving the second table down a row which it doesn’t like. Is there a work around for this.

Cheers,

I really wish I could delete this thread. I've been trying to solve this for ages and as soon as I posted this the answer dawned on me.. The table below is one column bigger..

Can I give myself reputation points??

I'm glad you replied as now I can't find how to mark it as solved..