VBA how to enter Array Formula in multiple cells

[Kishan]

Using Excel 2000</SPAN></SPAN>

Hi,</SPAN></SPAN>

I need to enter Array Formula in range B4:O4 at once through VBA, and copy down to B4:O20. How can be done please advise VBA code.</SPAN></SPAN>


Thank you in advance</SPAN></SPAN>

Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[AlphaFrog]

    Range("B4:O4").FormulaArray = "Your formula here"
    Range("B4:O4").AutoFill Destination:=Range("B4:O20")

 

[Kishan]

    Range("B4:O4").FormulaArray = "Your formula here"
    Range("B4:O4").AutoFill Destination:=Range("B4:O20")

AlphaFrog, code worked like a charm</SPAN></SPAN>

Thank you for your help and time</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Kishan </SPAN></SPAN>