May I know why this error will sudden occur

Help Studio
1

image
image1920×1033 123 KB

image
image1361×697 61.6 KB

Can anyone help me cope with this issue… many thanksss
Although the robot is quite long, I still feel little hard to do so…

I want to confirm the variable is right?

image
image1920×1033 137 KB

FA Sorting MU-rep MU-bias try.xaml (147.4 KB)

1 Like
2

Hi,

This error shows there is illegal excel cell address : LastRow variable is -1.
So, in the previous activity, Type column seems blank as LastRow is -1. Can you check if Type column has data and share how to handle if Type column has no data.

Regards,

3

Hi @Happydayyy ,

Try to execute the same lookup formula manually. You will receive same error manually as well. Reframe the look-up formula & use same in bot.

Thanks

4

may I ask how I can edit the formular? In this formular, I want to count the text in column K which is other than 3N, 4N, KR, Ky, Kw(Ni), Kw(Pd)

5

the problem formular is:
“=COUNTIFS(K2:K”+LastRow.ToString+“, “”<>3N”“, K2:K”+LastRow.ToString+“, “”<>4N”“, K2:K”+LastRow.ToString+“, “”<>Ky”“, K2:K”+LastRow.ToString+“, “”<>KR”“, K2:K”+LastRow.ToString+“, “”<>Kw(Ni)”“, K2:K”+LastRow.ToString+“, “”<>Kw(Pd)”“, K2:K”+LastRow.ToString+“, “”<> “”,K2:K”+LastRow.ToString+“,”“<>”“)”

6

May I know how i can revise?

7

Hi,

As I mentioned in my previous post, can you check if Type column has data and share how to handle if Type column has no data?
For example, do not write formula, or handle lastPopulaterow as 2 etc.

Regards,