I am just starting with JavaScript in Excel, and I have downloaded the "Excel JavaScript UDFS" book from this site.
I have installed the sample add-in, but I have a problem with the RangeAverage function:
With a large range (e.g. 1 column x >500,000 rows) it returns #NA #.
After returning this error it doesn't work on small ranges, until I restart the addin.
So the questions are:
Is there any way to set up JavaScript UDFs so they will deal with ranges of any size?
Is there any way to trap errors so you don't need to restart the addin every time an error occurs?
I have installed the sample add-in, but I have a problem with the RangeAverage function:
With a large range (e.g. 1 column x >500,000 rows) it returns #NA #.
After returning this error it doesn't work on small ranges, until I restart the addin.
So the questions are:
Is there any way to set up JavaScript UDFs so they will deal with ranges of any size?
Is there any way to trap errors so you don't need to restart the addin every time an error occurs?