IF Function strange bug

[Merlini]

Hi all,

Iam trying to autofill an Excel and the following code gives a strange fault:

ActiveWorkbook.ActiveSheet.Range("T2:T50").FormulaR1C1 = "=IF((RC[-9])>(R[-1]C[-9]), RC[-2], RC[-1])


The formula isn't correct on row 10, 20, 30 and so on because it uses row 1, 2, 3 and so on.
Any one of You knows why this is? Or has a solution?

Thanks in advance!

 

[Fluff]

What exactly is wrong with the formula in row 10?
I get K10 > K9 which I would expect

 

[Merlini]

The formula in row 10 becomes:

=IF((K1)>(K9); R1; I1)

All where 10 should be there is a 1.

 

[Fluff]

This is what I get
=IF((K10)>(K9), R10, S10)
If you run that one line of code on a new (blank) sheet what do you get?

 

[Merlini]

Then I get the good formula indeed. Strange. I'll start in a new sheet. Thanks for helping!

 

[Fluff]

Glad to help & thanks for the feedback.
Might be worth checking if you have any event code on the sheet, that could be messing up the formula.

 

[Merlini]

I found my mistake. Before the formula I changed all the "0" in "". Now I do that afterwards.