Count number of arguments to Excel formula in VBA

Posted by Abiel on Stack Overflow See other posts from Stack Overflow or by Abiel
Published on 2010-04-12T02:03:33Z Indexed on 2010/04/12 2:13 UTC
Read the original article Hit count: 384

Filed under:
|

I need to use VBA to determine the number of arguments passed to an Excel formula. For instance, suppose a cell contains the formula =MyFunc($A$1, "xyz", SUM(1,2,COUNT(C1:C12)), IF(B1>2,1,0)). Then the counter function should return 4. Does VBA contain any built-in functions for this, or does someone have an example of a regular expression that could calculate this?

© Stack Overflow or respective owner

Related posts about vba

Related posts about excel