How can i add an arrayformula in VBA when formula exceeds 143 characters

[EdH]

When i try to add an array formula using VBA, if the formula expression exceeds 143 characters in length, i get an error message. But when i go directly into the cell and edit it, i can add longer array formula. Is there a workaround in VBA that will allow me to overcome the 143 limitation?
Thanks for any suggestions.
EdH

[mehmetcik]

Could you not seperate one or more parts of your formula into VBA or Sheet variables to reduce the length of the text that way?

[EdH]

Thanks for the suggestion of splitting the formula into smaller parts. I'll give it a try this evening.

[EdH]

Mehmetcik, i tried your idea of splitting the formula up and after several tries i got it to work. Not completely sure what the maximum character limitation is when adding arrayformula or where to look this up. Thank you for your earlier response and help. I'm new at posting and responding. I think i showed that my original post is resolved but if i didn't do it right, please someone tell me how. Thanks