ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is there a rule for number of variables and characters used in a function (https://www.excelbanter.com/excel-programming/323302-there-rule-number-variables-characters-used-function.html)

Dave[_2_]

Is there a rule for number of variables and characters used in a function
 
Hello,

We have a custom function that uses 29 variables as input. We tried 30 but
it would not work.

It works with 29 but now when we select the function using the "paste
function" button we get no variable names to the left. I found that if I
reduce the total number of characters in the variable names combined to less
than 214, it works.

Is there a rule that says how many variables are allowed in a function AND
how many characters are allowed?

thanks - it will help us with future projects.




All times are GMT +1. The time now is 07:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com