Formula

For the life of me I can’t figure this out, but for a Type into I want to type a formula. The column is set (in this case column G) but the row, I want to use the LastRowIndex + 5. So if the Last row was 80, I want to type in cell G85.

Thanks

@RPANovice1

Is this for StudioX or Studio Pro?

Thanks

@RPANovice1

IF this is of StudioX then check as below

  1. Use Excel File Activity
  2. Inside the scope place Find First/Last Rows activity
  3. Declare a Int32 variable for the Save last row numbers
  4. Then you can declare Save for later intIndex + 5

For Studio

  1. Use Read Range activity → Declare a variable for DT
  2. Use Assign Variable and write as Dt.Rows.Count.ToString
  3. which it will store all the rows count
  4. now use write cell activity and write as Cint(Variable)+6

Hope this may help you

Thanks

Thanks, I did not realize the Number option was for formulas and the like!

Thanks

1 Like

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