Relative cell reference in excel using numbers

excel-loop
cell
active-cell
cell-value
excel

#1

Hi there,

Is there a way to specify relative cell references for the “Set/Get” actions using numbers instead? Kinda like how it works in Excel Macro.

For instance, if active cell is A2 and I want to get or set cell value; 5 cells to the right and 1 up, we can specify relative cell reference to be [5,-1].

The only way in the current version of RPA Express recorder (Version 1.1.4), is to use multiple “set active cell” --> “Cell to the right” and then “Cell above”.

Wouldn’t a relative cell reference in numbers be more efficient/faster to process? It certanly will lessen the work when setting and creating actions while developing actions/processes when we need to use data in Excel :slight_smile:

I also do not want to use absolute coordinates, as I use relative cell references to loop through an Excel file.

On the other hand, thanks for the amazing work you guys at WorkFusion are doing!

Kind regards,

Calvin Tran


#2

@Calvin_Tran,

Thanks for your idea!

As a workaround, you can place the Set Active Cell inside the Repeat loop and set the number of repeats.

Vote for this feature to raise its priority.