How to use ActiveCell.FormulaR1C1 1

[Louise99]

I wrote a macro in 97 to copy a simple formula down from the top cell to the bottom (ActiveCell.FormulaR1C1 = "=RC[-1]-RC[-5]"). Now, I find that I need to add an "if" statement. If the RC[-1] is less than zero, then I want "na" in the formula column. So, I thought that I could just use the statement ActiveCell.FormulaR1C1 = "if (RC[-1]>0,RC[-1]-RC[-5],na)". That didn't work so well! I need help using ActiveCell with a formula. Any help appreciated greatly!!!

Peace,
krfb

 

[SkipVought]

Hi,

I never liked abusing myself. So I GREATLY prefer A1 notation to R1C1.

But here goes...

ActiveCell.FormulaR1C1 = "=if(RC[-1]>0,RC[-1]-RC[-5],NA())"

Skip,
[sub]
[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large! [/sub]

 

[Louise99]

It worked. Skip, YOU ROCK!

Thanks!kb