PLZ, Need help with Arrayformel in vba... urgent

Hi,
i have an problem with an arrayformula, that i´m writing to a the cell (F27) in
the following way:

Please Login or Register  to view this content.

the cells in (B26:E26) i filled with the value 25, the cells (B27:E27) with the start value of 2.
i`m using the following code to set the cells:

Please Login or Register  to view this content.

in the result cell (F27) the error message #VALUE! (in german #WERT!) occured.

to figure out, whta is the problem i changed the code to this:

Please Login or Register  to view this content.

note that i´m using now the verticaly cells (G3:G6) instead of (B26:E26), filled them the same way as
before with "cells().value". but now, the formula is working fine, the value in the
result cell (F27) is 2, as it should be.

but where is the problem? why the formel doesn't work in the first example?

thanks for a help and regards
thorsten

MMULT requires the second array to have the same number of rows as the number of columns in the first array. your original formula doesn't do that so it won't work-you'd need to transpose the second array.

hi,
thx for your replies.
another user from another excel forum send me this version:

Please Login or Register  to view this content.

this formel works fine for me and does the job :-)

regards
thorsten

glad you got an answer but please read the rules on crossposting

Crossposting ? why crossposting ?

I assumed from "another user from another excel forum send me this version" you had posted this on other forums too.