unable to set formulaarray property of the range class

[Barbatian]

Hello,

I know this is a common error but can't see a reason why I receive such error:

.Range(.Cells(2, Date_Column), .Cells(LPF_LastRow, Date_Column)).FormulaArray = "=MAX(('Data Base'!B$2:B$20000=B3)*('Data Base'!C$2:C$20000))"

It doesn't reach 255 character I guess.
When I do this with Formula only it works.

Would be thankful for help.
Best Regards

 

[RoryA]

That won't do what you need even if it did work. You need to array enter it into one cell and then fill down, so you need this:

With .Cells(2, Date_Column)
.FormulaArray = "=MAX(('Data Base'!B$2:B$20000=B3)*('Data Base'!C$2:C$20000))"
.Autofill Destination:=.Range(.Cells(2, Date_Column), .Cells(LPF_LastRow, Date_Column))
End With

 

[Barbatian]

Ohh, why am I so stupid. Jesus. Thank you very much. It worked for inserting Array into the cell, however .autofill didn't work with following error:
"Autofill method of Range class failed"

 

[RoryA]

What's the value of LPF_LastRow when you run the code?

 

[Barbatian]

First of all big thank you since your provide comprehensive solution.
The problem with autofill was with:
.Range and .Cells, which refer to "With .Cells(2, Date_Column)" but should refer to Worksheet, so the final version is:
.Autofill Destination:=ws_LPF.Range(ws_LPF.Cells(2, Date_Column), ws_LPF.Cells(LPF_LastRow, Date_Column))

Thank you so much!!