Write cell issue if no data

[Happydayyy (22035153d)]

May I ask that there will be a problem if there is no data in "MU-bias (OUTRange)

can i know how i fix it ? Many thanks!!!

Main MU-bias (combined count (mainsheet).xaml (66.7 KB)
Excel
WB templ. 27.2.24.xlsx (68.9 KB)

[Yoichi]

Hi,

As there is no row in “Type of sample” column, lastrow variable will be -1 and it causes this exception.
How about set “First empty row”?

Regards,

[Happydayyy (22035153d)]

i HAVE try to use another solution that mean directly write cell the number from main sheet. However, there is something error while running the robot.

Can you help me to check on it and revise it?

Many thankss

robot
Main MU-bias (combined count (mainsheet).xaml (63.3 KB)
excel
WB templ. 27.2.24.xlsx (69.4 KB)

[Yoichi]

HI,

Can you share expected formula? The above seems wrong formula.

Regards,

[devik (Devi Kandasamy)]

Hi @Happydayyy If you want to copy value from sheet MU-bias (Robot) Cell T2, then What to write should be “=‘MU-bias (Robot)’!T2”

[mkankatala (Mahesh Kankatala)]

Hi @Happydayyy

I have modified the Workflow for this,
→ insert the Write cell activity and give the below expression in What to write field,

"='MU-bias (Within Range)'!T2"

Check the below workflow for better understanding,

Main MU-bias (combined count (mainsheet).xaml (65.1 KB)

Output:

Hope it helps!!

[Happydayyy (22035153d)]

thanks you so much. the issue is fixed!!

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @Happydayyy

Happy Automation!!