I am trying to use UiPath to copy and paste for a defined range.
I have the start and end range defined but the column changes everytime.
Is there a way for UiPath to read cell and pick up the column alphabets? The rows are fixed.
For example, I have defined cell B19 as my start column and C19 as the end column as generic values. (these columns will change).
I would like UiPath to read range from startcolumn row 6 to endcolumn row 10.
Does the below work or will I have to add .ToString to it?
I have tried defining my Start and End Column and keyed in the below in read range. (StartColumn)+“6”+“:(EndColumn)”+“10”
However, I’m getting the below RemoteWrap error saying it cannot read the below:
JK6:(EndColumn)10
Looks like it picked up the cell correctly except for the (EndColumn) is not reflecting as JJ.
Do I have to add any To.String behind?
Thanks @jack.chan , it works for read and write range.
However, when I’m using it for autofill range to copy and paste formula within that range, I’m seeing the below error. Does it not work for autofill range?
Thanks!
Function CopyAndPasteRange(copyRange As String, pasteRange As String, sheetName As String)
ActiveWorkbook.Sheets(sheetName).Activate
Range(copyRange).Select
Selection.Copy
Range(pasteRange).Select
ActiveSheet.Paste
ActiveWorkbook.Save
End Function