constant in a .formula statement

[basbrian]

I am currently using the following code to populate cells with a formula

Dest.Cells(sRow, 10).Select
ActiveCell.FormulaR1C1 = "=if(RC[-2]<>""-"",(RC[-2]-RC[-1]),"""")"

I am now going to have a variable number of columns that this formula has to go in and also the RC[-1] col is going be always col A.
How do I change RC[-1] to refer to col A??

 

[PHV]

RC1

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[basbrian]

PH,
when I use RC1, I get the value from cell srow,11 and not srow 1 (srow:A)

 

[PHV]

I said RC1, not RC[1]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[basbrian]

Thanks for that.