Autofill FormulaArray with vba

[Zer0aim]

Hi all.
Trying to get this fromulaArray:

" =MIN(IF(Data!C[-1]=R[1]C[-1];Data!C;""))" or " =MIN(IF(Data!A:A]=A2;DataB:B;""))"
to fill a range e.g B2:B50

Ive read and tried diffrent thing but wasnt able to work around the errors i got.
My last attempt i recorded a macro and got this code to work with

Please Login or Register  to view this content.

And still not working. It adds the formula in column c and its a "normal" formula not an Array. And give me
Error code: Runtime error 1004 "autofill method in ranged class failed"

This code should be added to the sheet when i create it with VBA. Sheet name "samman"

Will not be able to reply to any response until tomorrow sadly.
Any Help or hints to work around this annoying problem is appreciated

Regards Zeroaim

[ragulduy]

I believe you can just do:

Please Login or Register  to view this content.

[Izandol]

Do you add the formula to column C or B?

[Zer0aim]

Yudlugar: Think ive tried it before but i tried again and got runtime error. Formula property Array can not be specified for the class range (google translated ).
A question about the formula. You added a R into the formula when excel just use C[-1]. Does it have any change on the outcome or can you skip it when you want to look in the whole column?

Izandol: This formula i want in the B column. Got more for C and D columns, but thats after i get the formula to work for B.

[Izandol]

You receive an error with the FormulaArray if there is a problem with the formula - such as no Data sheet. The Autofill will fail if the cells are not empty. You may try:

Please Login or Register  to view this content.

[Zer0aim]

Izandol

The formula works when i manually enter it and hit CSE. And regarding the autofill, The sheet is created when i hit the button.
It enters text into A1:D1 and formats column B,C,D with [h]:mm formating rest is clean.

[Izandol]

May you provide the whole code? The portion you have provided runs here without problems.

[Zer0aim]

Sure

Please Login or Register  to view this content.

If you want something translated let me know

[Izandol]

FormulaArray should be entered to one cell and use comma notation with escaped quotation marks:

Please Login or Register  to view this content.

It will be slow calculation with whole columns however!

[Zer0aim]

Thanks Izandol for all the help.
Just have to trim the range alot