Cellrange

Help Activities
, , , ,
1

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.

2

@Pushpendra_kowthavarapu

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

3

@Pushpendra_kowthavarapu

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.

4

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).

5

@Pushpendra_kowthavarapu

use this

inputcelladdres.Substring(0,1)+CStr(CInt(inputcelladdres.Substring(1,1))+1)

input cell address is the output of look up range

image

6

HI @Pushpendra_kowthavarapu

You can try like this in the below image

Excel.Sheet("Sheetname").Cell("B"+(CDbl(System.Text.RegularExpressions.Regex.Match(Lookup_Output,"\d").Tostring)+1).ToString)

image
image787×378 12.8 KB

7

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