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

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

IF this is of StudioX then check as below

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

For Studio

- Use Read Range activity → Declare a variable for DT
- Use Assign Variable and write as Dt.Rows.Count.ToString
- which it will store all the rows count
- 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.