Excel constants

[Guest]

Re-posted from

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=364752&SiteID=1

Dear all,

I can get the maximum limit of Excel (vary on different version) by using,
e.g. Rows.Count and Columns.Count), and I'd like to know how I can get the
maximum number of character per a formula? (E.g. 1024 for Excel 2003), or
more generally, how I can get all Excel build-in constants?

Thanks,

 

[Guest]

the constants are in the type library.

See Chip Pearson's downloads page:
http://www.cpearson.com/excel/download.htm

TLIUtils.

You can view them manually in the object browser.

You can search Excel help for limitations for limits in Excel.

there is no constant for maximum number of characters in a formula and to
the best of my knowledge, it hasn't changed between versions.