Add formula in the code
 

How would I add this formula into the code on Sheet2?

=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)

Add formula in the code
 

What does that mean - add it into the code on sheet2?

If you wanted to use code to enter that formula in a cell you would do:

Worksheets("Sheet2").Range("F6").Formula = _
"=SUMIF(Sheet1!B:B,""warrant"",Sheet1!C:C)"

--
Regards,
Tom Ogilvy


"Annette" wrote in message
...
How would I add this formula into the code on Sheet2?

=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)

Add formula in the code
 

Very intuitive and just what I needed ... this makes sense and also helps me
for the other formulas! Thanks!
"Tom Ogilvy" wrote in message
...
What does that mean - add it into the code on sheet2?

If you wanted to use code to enter that formula in a cell you would do:

Worksheets("Sheet2").Range("F6").Formula = _
"=SUMIF(Sheet1!B:B,""warrant"",Sheet1!C:C)"

--
Regards,
Tom Ogilvy


"Annette" wrote in message
...
How would I add this formula into the code on Sheet2?

=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)

Add formula in the code
 

TIP
To enter formula down a column:
With Range("D7:D27")
.FormulaR1C1 = "=somefunction(RC1)"
End With


"Annette" wrote in message
...
Very intuitive and just what I needed ... this makes sense and also helps
me
for the other formulas! Thanks!
"Tom Ogilvy" wrote in message
...
What does that mean - add it into the code on sheet2?

If you wanted to use code to enter that formula in a cell you would do:

Worksheets("Sheet2").Range("F6").Formula = _
"=SUMIF(Sheet1!B:B,""warrant"",Sheet1!C:C)"

--
Regards,
Tom Ogilvy


"Annette" wrote in message
...
How would I add this formula into the code on Sheet2?

=SUMIF(Sheet1!B:B,"warrant",Sheet1!C:C)