Excel Constants

P

Peter

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Throwing #Value in a UDF written in Excel VBA 4
excel spreadsheet functions written in vba 1
Finding last constant in range 1
Excel User Defined function calling RTD 0
Excel User Defined function calling RTD 1
Influence of IsEmpty function 6
how to add tooltips to excel udfs i created? 7
Creating UDF prompts (XL 2007) 3

Top