02-24-2023, 07:59 AM
A few notes:
To get the Developer Toolbar (on Excel for Mac):
Next:
This is a typo. This is a "smart quote". That will not compile. The leading character needs to be a single quote ('). Remember, "smart quotes are evil".
This is another typo. That semi-colon needs to be a colon.
After that, I got this to run :-)
To get the Developer Toolbar (on Excel for Mac):
Quote:Excel > Preferences > Ribbon & Toolbar > Customize Thie Ribbon > [check box for Developer]
Next:
Code:
‘Returned value is a string, not a numberThis is a typo. This is a "smart quote". That will not compile. The leading character needs to be a single quote ('). Remember, "smart quotes are evil".
Code:
=AddMult(ZZ;XX)This is another typo. That semi-colon needs to be a colon.
After that, I got this to run :-)