Problem Copying Table Column to Another Table

I am trying to copy the first column of one table to the first column of another table.

The code first deletes all the data in the receiving table while preserving formulas. But when the new data is pasted the results extend beneath the table's total row. The table is not expanded to receive the new data.

Here is the code.

Please Login or Register  to view this content.

Any help would be most appreciated.

Thanks!

...Upon further checking, I might need to Resize the table before pasting but I could use some help with that syntax.

Thanks, again for checking on this.

...SOLVED...I think. I just learned that when copying data into an existing table that the totals row must be turned off.

Please Login or Register  to view this content.

With that addition, the code above works. After new data is added we can turn totals back on with

Please Login or Register  to view this content.

Many thanks to all who were looking in on this problem.

tom