Read range(settings and constants sheet) object reference not set to an instance of object error throwing

Can anyone please help what’s the issue?

@vnsatyasunil ,

the value of the sheet name is “exception” , so there is no sheet name with name Exception in the config file

@vnsatyasunil ,
If you see the locals panel you can see the value of the sheet is “Exception”

@vnsatyasunil ,
Kindly check that the config filepath and sheet name exists and it is matching the cases too with the real file (Camel case/upper/lower)

if there is no such sheet needed, then remove the value of sheet name from the array argument (Default value field)

@vnsatyasunil ,
Try printing config filepath in a message box and check the value inside initallsettings workflow , Anyways 100% sure this issue is due to no proper value in the arguments

ya.thanks.issue is in the exception sheet

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