FormulaArray

Hi,

See attached file .

I have two formulas almost identical. On formula1, I have an INDEX function and on formula2, I just add an IF statement with ISERROR "=IF(ISERROR(INDEX(...);"";INDEX(...))."

Both formulas work fine, but when I record a macro with each formula, only the 1st is working. What do I have to change on formula2 to make it work?

Check the macros on module1

Regards,
Elio Fernandes

The formula is too long ( over 255 characters). However, as you are using 2007 or later, you can shorten it with IFERROR:

Please Login or Register  to view this content.

Your formula is to long for .FormulaArray this is limited to 256 characters.
Try this, Rename your Table "tbPlanSem" to a shorter name, I have used "tbPS" in this example

Please Login or Register  to view this content.

You will obviously have to change this name in both macros.

Hope this helps

[EDIT]
Didn't see your reply romperstomper

For this example its working. Thanks to you both.

What can I do if I have formulas about 400 characters and I can not reduce them in any way?

Regards,
Elio Fernandes

You can either shorten it by using names or, if it really must exceed the character limit, you can use the Range.Replace() method outlined here:
http://www.dailydoseofexcel.com/arch...rmulas-in-vba/