ActiveCell.Formula If Statement

[davidam]

Hello again,
This works fine if I have a number as the second choice in the If statement, how can i get the formula to have "-" at the end of the statement?

RowForm = 40
ColForm = -7
    ActiveCell.FormulaR1C1 = "=If(Isnumber(R[" & RowForm & "]C[" & ColForm & "])=True,  R[" & RowForm & "]C[" & ColForm & "],"-")"

Thank you,
David

 

[wigi]

Hi

Use:

""-""

(so double the quotes)

 

[davidam]

A thing of beauty! Thanks