View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default More than i substitution

Amen. Otto
"Ron Rosenfeld" wrote in message
...
On Mon, 19 Nov 2007 12:33:12 -0800 (PST), iliace
wrote:

You can nest 64 formulas in Excel 2007, though I doubt anyone would
ever want to. The formula length limit is about 8,000 characters.


That's quite a jump from seven.

For me, when nesting is more than a few deep, I find it simpler to just
write
(and certainly simpler to debug) a VBA UDF.
--ron