Run-time error '1004': Unable to set the FormulaArray property of the Range class

Hi, i am trying to set formula using VBA, but i keep getting that error '1004'. I checked and my formula isn't longer than the maximum array size (255).

Please Login or Register  to view this content.

What's the problem?

Hi Lomoo,

Try use comma instead of semicolon.

Hi, huuthang_bd,

no more errors, but now the cells turns like : #NAME?

Here is the code :

Please Login or Register  to view this content.

Hi again,

The formula return #Name error because the functions is not defined. What are the SE and LUNGHEZZA functions in your formula?