Copy and paste formula

victorialim · May 1, 2022, 6:23pm

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.

Rahul_Unnikrishnan · May 1, 2022, 7:05pm

Plz refer the below post.

Yoichi · May 1, 2022, 11:25pm

Hi,

Another solution:

We can achieve it using Copy/PasteRange as the following.

Regards,

Topic		Replies	Views
How to copy formulas into excel cells using read range and write range Help excel , uiautomation	2	2066	January 6, 2020
How to copy the excel column formula to the newly added rows Help	7	5924	August 1, 2019
Copy Paste Range in Excel StudioX studiox , question	5	1879	September 22, 2022
Copy Row, Paste Row, Remove Row, Move Row, how to do all this stuff in Uipath? Automation Starter excel , activities , studio	3	1036	September 19, 2022
How to copy an excel range to clipboard using "Copy/Paste Range" from "Ui.Path.Excel.Activities" Activities excel	2	2652	June 8, 2021