ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Constants (https://www.excelbanter.com/excel-programming/359661-excel-constants.html)

Peter

Excel Constants
 
Hi,

I want to construct a formula for a Excel cell, but I got an exception. So I
want to know how I can get the constant / limits of Excel (vary on different
version)

1. Number of arguments per UDF
2. Length of characters of an argument in UDF
3. Length of characters per UDF (1024 for Excel 2003, but how I can get this
'figure' programatically?)

Thanks,


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

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