Hi All,

I have a macro that takes data from 2 different worksheet tables in a closed workbook and combines them into a single table in an open workbook.

The problem I am having with the code is that:

1) After the 2nd table is added to the first, there a whole bunch of empty rows below it - See attached image (more than 5000 rows, I deleted them the illustrate my problem).
empty space.jpg
2) When I add code to add a 3rd table to the 'new table' it appears below the empty row as seen in the image

How do I get rid of the rows? I think this arises from the use of:
Please Login or Register  to view this content.

The full macro below:

Please Login or Register  to view this content.
Thanks all :D