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