ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   TIP: How to avoid losing your arguments in a UDF (https://www.excelbanter.com/excel-programming/351526-tip-how-avoid-losing-your-arguments-udf.html)

pinkfloydfan

TIP: How to avoid losing your arguments in a UDF
 
Yesterday, I posted a problem I was having with some UDFs: basically,
the functions worked as planned but the argument list did not come up
no matter how the function was inserted.

After much debugging I believe I have solved my problem and post it
here to share with you. It appears that there is a limit of 255
characters for the total characters used to name arguments in a
function: if the total is greater than this then the argument list will
not display but the function will continue to work.

I am using Excel 2002 (10.6501.6714)

All the best
Lloyd



All times are GMT +1. The time now is 12:20 AM.

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