Forum Discussion
Solved
Can't invoke a UDF from an excel sheet
I have office 365 and i can't invoke ANY user defined function. For example - I have tried simple adding two numbers function. Function add2numbers(x As Integer, y As Integer) As Integer
add2num...
Do you use comma as decimal separator? If so, use semicolons in the formula:
=add2numbers(3; 4)
Do you use comma as decimal separator? If so, use semicolons in the formula:
=add2numbers(3; 4)
Yes, Using SEMICOLON as a list separator RESOLVED the problem.
Due to my current regional settings, i was unaware that i was having Semicolon as List separator and i was constantly trying to invoke with comma.
Now, I have changed my regional settings, which has comma as a list separator.
I can now use COMMA to call a UDF.
Thank you very much for your time and assistance.