I am having issues with Append Range adding blank lines. My process takes one data table and appends it to an excel spreadsheet. The spreadsheet has alot of formulas that is expanded into the new data correctly. I close the spreadsheet and when I try to append another similar data table it is always leaving blank lines (sometimes over 100). The data gets appended after the blank lines and as a result is not formatted into my table on the master spreadsheet.