May 13, 2016 15:38 ANSWERED
I have a Datatable i have made by reading a Range from Excel sheet.
I want to save the Datatable to another Execl Workbook and new sheet.
I can do this. but I need to have the Range of the DataTable im saving in the new Excel Sheet…
Eg. The Datatable have 15 coloumns with 50 Rows. and I Write Range a “Sheet1!A10”
Then I want to get a return range somhow from the system that the DataTable have the following Range “A10:M60” or so.
Then I can save this Range for the NeXT load of the DataTable with a RangeRead with Range “A10:M60” and only get the active rows of the Datatable.