using VBA to add new rows under an existing table

[dcwan]

Hello

I have been working on some VBA code in which I'm adding new rows under an existing Table. In the 1st scenario, I start off with a Table and a blank row, and I add new rows to my table (see "scenario1" worksheet. This is fine as expected.

In the 2nd scenario, I start off with a Table and several rows that have already been filled (see see "scenario2" worksheet) . When I run my VBA code (clicking on the "Create New Issues" button), I get a border line after the prefilled rows (see "scenario2_actualresult" worksheet).

However, I would like to create a result that looks like "scenario2_idealresult" worksheet.

Given that there is a border that is created on the entire row, I could use VBA code to delete the row, but that seems like a brute force method. Is there something else inherent in my code that naturally creates a border?

Thanks