Had to open an incident for this, and got the resolution. So the way to define dynamic range
Where A is your first column and Z is your last. The columns cannot be used dynamically, only the rows
Columns can not be defined dynamically. IRPA team should update the help documentation with this info.