FormulaR1C1

[lezhi]

I was trying to use formulaR1C1 function calculate as below:

MyCount = Application.Count(Range("A:A")) + 4
ActiveCell.FormulaR1C1 = _
"=IF(AND(R[2]C=""Adj Close"", R[MyCount]C<?XML:NAMESPACE PREFIX = MIN(R[3]C /><MIN(R[3]C:R[MyCount R[MyCount]C Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), ->MAX(R[3]C:R[MyCount - 1]C)), ""buy"", """"))"

It gave error of "Application defined or object defined error" when I put "MyCount" instead of numbers into the brackets after "R". Does that mean, only numbers are accepted in this FormulaR1C1 function? Is there any other method can help me to do the calculation?

Thank you,

Rachel
</MIN(R[3]C:R[MyCount>

 

[shg]

Welcome to the board.

This would work ...

... = "=IF(AND(R[2]C=""Adj Close"", R[" & MyCount & "]C<?XML:NAMESPACE PREFIX = MIN(R[3]C /><MIN(R[3]C:R[MyCount - 1]C)), ??sell??, IF(AND(R[2]C="" Adj Close??, R[MyCount]C>MAX(R[3]C:R[" & MyCount & " - 1]C)), ""buy"", """"))"</MIN(R[3]C:R[MyCount>

<MIN(R[3]C:R[MyCount - 1]C)), ??sell??, IF(AND(R[2]C="" Adj Close??, R[MyCount]C></MIN(R[3]C:R[MyCount>
<MIN(R[3]C:R[MyCount - 1]C)), ??sell??, IF(AND(R[2]C="" Adj Close??, R[MyCount]C>... but for CMAX; what is that?


</MIN(R[3]C:R[MyCount>

 

[lezhi]

Welcome to the board.

This would work ...

... = "=IF(AND(R[2]C=""Adj Close"", R[" & MyCount & "]C<?XML:NAMESPACE PREFIX = MIN(R[3]C /><MIN(R[3]C:R[MyCount R[MyCount]C Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), ->MAX(R[3]C:R[" & MyCount & " - 1]C)), ""buy"", """"))"</MIN(R[3]C:R[MyCount>

<MIN(R[3]C:R[MyCount R[MyCount]C Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), -></MIN(R[3]C:R[MyCount>
<MIN(R[3]C:R[MyCount R[MyCount]C Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), ->... but for CMAX; what is that?


</MIN(R[3]C:R[MyCount>

Thank you for the answer. the code should be:

ActiveCell.FormulaR1C1 = _
"=IF(AND(R[2]C=""Adj Close"", R[" & MyCount & "]C>MAX(R[3]C:R[" & MyCount & " - 1]C)), ""buy"", """"))"



<MIN(R[3]C:R[" Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), - p & MyCount ? <><MIN(R[3]C:R[" Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), - ?]C & MyCount R[? ?><MIN(R[3]C:R[" Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), - ?]C & MyCount R[? ?><MIN(R[3]C:R[" Close??, Adj IF(AND(R[2]C="" ??sell??, 1]C)), - ?]C & MyCount R[? ?>The compilor still gave me the same error after I replaced "MyCount" with "&MyCount&"...Could u please help?

Thanks,

Rachel
</MIN(R[3]C:R[">
</MIN(R[3]C:R[">
</MIN(R[3]C:R[">
</MIN(R[3]C:R[">

 

[lezhi]

I got it. if i put "-1" into "& &" it works. Thanks a lot!