Autofill Range copy

[Raj_Nadar (Raj_Developer)]

Autofill Range not able to fill the last rows and tried even assigned the variable “H2:H”+DT.Rows.Count.ToString but its avoiding last Rows filling range (I mean formulas)

something missing for declaring the variable +1, please suggest

[AndresTarazona]

Hi @Raj_Nadar

You can use this into your solution

@Raj_Nadar

“H2:H”+DT.Rows.Count.ToString

So, just remember, the DataTables, in your case, the DT, it starts to count the rows from position 0, and in Excel the spreadsheet starts to count the rows from position 1. You can use the required range as follow:

“H2:H”+(DT.Rows.Count+1).ToString

Regards,

Andres Tarazona

[Raj_Nadar (Raj_Developer)]

Its working fine…Thanking you so much Andres Tarazona