Set formula in cell using VBA

[Arie Bos]

I want to enter the following formula's in two cells:

    Range("D61").Select
    ActiveCell.FormulaR1C1 = "=SUM(D58:D60)"
    Range("D63").Select
    ActiveCell.FormulaR1C1 = "=COUNTIF(IG_TxnHist[ProfitAndLoss];"">0"")-1"

the result in D61 is =SUM('D58':'D60') and returns a #NAME ? error. How to avoid the apostrophs around the range reference?

the second one returns an 1004 error: "Application defined or object defined error", but I do not see why.

Any help is greatly appreciated.

Arie

 

[Logit]

.
I'm confused ... you are selecting either D61 or D63, then pasting a formula in A1 both times. ???

 

[Fluff]

Try

    activecell.Formula = "=SUM(D58:D60)"

 

[Norie]

Try this.

Range("D61").FormulaR1C1 = "=SUM(D58:D60)"
Range("D63").FormulaR1C1 = "=COUNTIF(IG_TxnHist[ProfitAndLoss],"">0"")-1"

 

[Arie Bos]

You are right, I made a mistake with the R1C1.
Thanks for the help, both formulas work fine now!

 

[Logit]

.
Oh geez ... I need more coffee.

Never mind. I'l be in the corner ... drooling.

 

[Fluff]

It works for me if I replace the ; with a , but I suspect that that is a regional setting.