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:
The full macro below:
Thanks all :D
Bookmarks