Write range error3

Help Robot
,
1

“C”+(Vendorread.Rows.indexof(CurrentRow)+2).ToString
I am writing this exp in the shell but its writing data in only c1
I want to write data In C2 And after again in loop C3
image
This is my excel sheet i want to write my data in a loop in status columnn

2

HI @Kuldeep_Pandey

Instead of using rowindex try using this property

image

Can you show or share the workflow you are using

cheers

3

image

4

I cant share my whole code

5

Hi @Kuldeep_Pandey

Can you try using the index property instead of rowindex

image

“C” + (index + 2).ToString

Create a index variable for the for loop in properties

cheers

6

I also want d in another write range

7

What i should write in index property

8

@Kuldeep_Pandey

the rowindex is returning -1 always …it is not able to search the row …so use index or use a loop counter

9

@Kuldeep_Pandey

press ctrl+k and create a variable…that stores the count of the loop basically

10

in the place of index property?

11

@Kuldeep_Pandey

image
image1783×656 46.1 KB

index - variable type int32

cheers

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.