Find Last Row in Data and Paste Excel Table Copied From Another File

Help StudioX
,
22

@Anil_G it says that the A:N range does not exist. I would like to copy the data and paste it in file 2 sheet1 columns A:N in the last row +1 containing values

23

@alberto.lombardi

Please show a screenshot of your setup and the exact error

Also you can try like below

Excel.Sheet("Name").Range("A1:N" + Excel.Sheet("Name").OutDataTableValue.RowCount.ToString)

Cheers