Hi Chuck:

According to the book "Excel 2007 - Beyond the Manual" by Helen Dixon, p 189:

"TIP
Excel 2007 can work with bigger formulas than ever before and can now deal
with 8,192 characters and 64 levels of nesting compared to 1,024 characters
and 7 levels of nesting in Excel 2003."

The link to an online page 189:
http://books.google.com/books?id=is2...um=2&ct=result

May you have a most blessed day!

Sincerely,

Michael Fitzpatrick


"Chuck" wrote:

On Sun, 5 Oct 2008 10:56:11 -0700, MichaelDavid
wrote:

By the way, can Excel 2007 handle 14 nested IFs like this?
No. 7 max. I didnt try to analize the Ifs. Are you currently runnibg this
code in Excel?

Don Guillett and Bob Phillips have given you the best advice you can get.

Chuck

No diagnostic
messages are ever displayed when I execute the macro containing this code.
This particular macro is executed approx. 30 times a week.