Code for Array formula

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

I have this formula that I'm trying to put in code, but is not reading
properly to show it is an array ... how would I add the array to handle that
part of the formula?


my code:

Worksheets("Sheet2").Range("b3").Formula = _

"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250=""E"")*(Sheet1!C2:C250))"
 
I found it ... I needed to add Array after the word formula ...
Worksheets("Sheet2").Range("b3").FormulaARRAY = _
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Blank cell criteria 2
My Never ending ARRAY code problems 18
Array VLOOKUP lookup_Value does not increment 3
CONCATENATE code 2
Cell values to an array, then array transpose to another workbook 8
Array code troubles 4
Naming non-contigent cells with vba 5
Help with an IF Formula 1

Back
Top