Auto Fill formula in excel

Help Studio
, ,
6

To fill end of the dataset,

  1. First get the number of rows in the excel. lets say “Dt1”
  2. RowCount = dt1.rowscount.tostring
  3. USe rowCount to define end of dataset. Example
    USe below code inside RANGE properties
    “E2:E”+ RowCount .tostring
1 Like