Hi, I do have a lookup range output variable. I am able to paste the data from the specific with the help of that (lookup range) output range. But i need to increment the +1 cell to the loopup range .Could someone help me how to write the expression for this.


can you share the output which you are getting from the look up range


Suppose you have a lookup range stored in a variable called lookupRange , and you want to increment the cell by one, you can do it like this:

lookupRange = lookupRange.Offset(1, 0)

This will move the lookupRange one cell to the right.

Output variable is Cell_value (String).With the help of this i was pasting some data as well from that specific range example (B3). But i need to write from (B4).


use this


input cell address is the output of look up range


HI @Pushpendra_kowthavarapu

You can try like this in the below image


Hello @Pushpendra_kowthavarapu
Trey this

  1. LookupCell=A5
  2. Column= System.Text.RegularExpressions.Regex.Match(LookupCell,“\D+”).Tostring.Trim` —> A
  3. RowValue = System.Text.RegularExpressions.Regex.Match(LookupCell,“\d+”).Tostring.Trim` —> 5
  4. You can use the above variable with Increment in the required activity
    Range-----> Column+(Cint(RowValue)+1).Tostring —>A6