Syntax Error with SpellNumber function in Excel 2013

Question

I had set up a template with the SpellNumber function in Excel 2010, which worked just fine.  When attempting to use it in Excel 2013, I receive the following syntax error:

The function was created using the steps in 

https://support.office.com/en-gb/article/Convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98

I can't seem to find information on how to correct this.

Answer 1

The underscore in the offending line was intended to be a continuation character, and the rest of the line should have been on the next line.

Remove the underscore _ to get rid of the error.

Answer 2

Thank you.  That seems to have removed one error, but not I'm receiving the following "Argument not optional" error:

I'm at a loss.  Please let me know if there is a way to correct this, or whether there is another function code I should be using to convert numbers to words.

Thanks.

Answer 3

Please remove the empty line below the line in red.

Answer 4

Unfortunately, this did not solve the problem.

Answer 5

Sorry, my mistake. Remove (delete) the empty line between

Result = Result & GetDigit _

and

(Right(TenstText, 1)) ' Retrieve ones place.