Hi Clemsoncooz
Where is the built table stored? Is it in another sheet of the same workbook?
My approach would be to read the built table, insert/delete the correct number of rows, then copy it in. Or, if I'm building it in the existing sheet, start with the 2 spare rows and insert additional rows as I went.
The VBA code to insert a row on Sheet 1 at Row 24 is:
To delete a row
To delete the blank rows, where there are more than 2, the following code would do it:
I'm not sure how to deal with the converse - where there are too few rows - without answers to my questions above. You could just insert 1000 rows (to be sure) then run the above code to delete them again once you've built your table. Not very efficient, but it would work:
Best regards, Rob.
Bookmarks