Copy and paste formula

Hi All,

I am trying to get UiPath to copy and paste formulas down the rows I have.

I have the start and end range defined.

I would like UiPath to copy the formulas I have from row 9 and paste it from row 9 to 14.

The start and end range may vary so they are not fixed numbers.

Any idea how i can go about doing this?

I used Readcell for M1 and N1 to define as my start and end range.

Should I use write and read range after that? I would like to copy the formulas within the row but not the values. Thanks.

Plz refer the below post.


Another solution:

We can achieve it using Copy/PasteRange as the following. (15.8 KB)