Here's my fiunction (inserted in Module1):
Function Add(number1, number2)
Add = number1 + number2
Then going back to Excel worksheet to enter my formula in A3 cell :
where A1 = 2 and A2 = 3 (formula should return 5 in cell A3) .
Everything seems ok until I type the second cell address "A2".
A pop up is then displayed saying :"The formula you typed contains an error....."
If I type a semi-colon instead of a comma, I get the #NAME? error in A3 cell.
If I use the insert function icon to enter my formula, I'm offered to select it in the "Select a function" list of available functions . The name of the function appears in the following style:
When I click ok a pop up box tells me : "This function takes no arguments." When I click ok on that one the formula appears in the formula bar with parenthesis but without arguments and the #NAME? eroor is displayed in A# cell.