Search Excel VBA help for: FormulaArray

Per that topic, the formula in the VBE needs to be in R1C1 format

Example:
Worksheets("Sheet1").Range("E1:E3").FormulaArray = _
"=Sum(R1C1:R3C3)"

Does that help?

Regards,

Ron Coderre
Microsoft MVP (Excel)

wrote in message
...
Hi,

I have formula ( Array formula)
=MATCH(B2&D2&F2,Sheet2!A:A&Sheet2!B:B&Sheet2!C:C,0 )

How Can we use in VBA
Application.worksheetfunction.match..........

How should I use same array formula in VBA.

Thanks in advance