Copy Paste Range with variable

Hi,

I want to copy and paste certain five cells in excel to the next 5 cells. (with formats). For example, copy the cells between “J132:J136” and paste them into cells in the range “J137:J141”. I want to get it from a variable as the ranges are constantly changing. But I couldn’t find how to use the two variables in the Copy Paste Range activity.

J132>range1
J136 > range2

range> range1:range2

Hi,

How about the following?

range1+":"+range2

Regards,

1 Like

I tried but I get this error.

Source: Copy/Paste Range

Original error message: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Exception Type: UiPath.Excel.ExcelException

HI @nilesay

Inside the Excel application scope use Kill process activity followed by Delay activity.

Processname → “Excel”

Regards
Gokul

1 Like

Check out the Screenshoy

it works! thank you

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