Menu
I created anew function in sheets from within a sheet. The function is not recognized:
function DOUBLE(input) {
return input * 2;
}
save
Go into the sheet, enter a cell and type =double(10)
Error "unknown function 'double'"
386
As for the custom ones, Excel cannot validate the VBA code and identify other cells that could also affect the result of the custom function. Therefore, your custom formula may not change when you make changes to the workbook. To fix the issue, you'll just need to use the Application. Volatile statement.
Calling custom functions To call a function, use @functionName or @functionName(); in the configuration options of the event handler. In the following example, your custom function is added to the On click event handler of a button.
Clearing my cookies seemed to do the trick. Not sure if that qualifies as an answer but if anyone else comes across this post I hope that helps.
99
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
