Macro returns #value error

[chrisk0420]

I recorded a simple macro that pastes a formula into a cell. When I run it, it pastes the correct formula but it returns a #value error. If I go into the formula bar and hit enter it then works fine.

Is this an issue with my settings or with the macro itself.

Here is the macro

Sub Macro1()
'
' Macro1 Macro
'
'
Range("M9").Select
ActiveCell.FormulaR1C1 = "=ROR(R[-7]C[-10]:R[-6]C[-10],2)"
Range("M10").Select
End Sub

 

[VoG]

Does this work?

Sub Macro1()
Range("M9").FormulaR1C1 = "=ROR(R[-7]C[-10]:R[-6]C[-10],2)"
End Sub

 

[Desu Nota from Columbus]

what is the formula suppose to do?



what is the formula once it is pasted in M9?


Possibly use instead

Range("M9").Formula = "=ROR(C2:C3, 2)"

 

[chrisk0420]

Thanks... it works when not in R1C1 format. This was actually just a small part of a more complex macro, but I have now made adjustments so is is not R1C1 and it is fully functional

Thanks for the help