What is this error? (Format Cells)

[helpplease]

Hi, i was formatting cells with values in them but i came across this error. What do I do?

[B_H_Akshatha_Pai]

kindly share your xaml

Regards

[efelantti]

It means some variable is null / Nothing. If you run your automation in debug mode, you can check your variables to see where the fault is.

[tazunnisa.badavide (Taj)]

If Possible Can you share some more details about the same

[helpplease]

i ran the debug mode, the values did changed to what i formatted it but then that error still pop up.

[supermanPunch (Arpan)]

@helpplease

the values did changed to what i formatted it but then that error still pop up

Hi @helpplease ,

Screenshots of the Check done through Debug would help us to identify what was wrong.

Maybe could also check with the below Post on usage of Format Cells activity :

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …