VB.Net / Excel - Determine range and append to end of another worksheet
Posted on 2014-01-22
I have vb.net code to delete a worksheet, then export an Access datatable to replace the deleted worksheet, call this "NewSheet".
Now I need to determine the range of data in "NewSheet" and append that range to the end of existing data in another worksheet "OldSheet" in the same workbook.
Both worksheets would use the same columns (say A,B.C).
The source range on "NewSheet" would start at "A2" and end at "C LastRow".
The destination range on "OldSheet" would need to start at "A LastRowOfExistingData +1".
I generally work with Access and have little experience coding for Excel. Can someone help me with this?