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 [autofillerror]

Hi @Raj_Nadar You can use this into your solution [image] 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 req…

Autofill Range copy

Help Studio

system (system) Closed May 23, 2020, 9:27am 4

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

Topic		Replies	Views
Auto fill range variable Studio excel , activities , question	8	4008	March 7, 2020
Autofill Excel Function Studio studio , excel-scope	5	1164	July 2, 2021
How to Add dynamique number of rows to Auto fill Range activity Forum question	8	1702	June 24, 2021
Error:auto fill range autofill method of range class failed Learning Hub	3	4738	April 9, 2020
Uipath Excel alternative way to find row without foreach Studio	2	1175	April 19, 2021

Autofill Range copy

Related topics