![]() |
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