Autofill Range copy

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

Hi @Raj_Nadar

You can use this into your solution

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:



Andres Tarazona

1 Like

Its working fine…Thanking you so much Andres Tarazona

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.