Trouble Setting Desirable Range

[ohFice]

Hi,

I am new to new forum, and new to VBA in general. I am trying to create a macro which sets a range of cells equal to themselves divided by a different range of cells, and multiplied by 12. Is this possible? I try to explain what I am trying to do via code that doesn't work below. I genuinely appreciate any assistance!

Sub Annualize()


Range(P59, P450) = Range(P59, P450 / Range(R59, R450)) * 12


End Sub

 

[footoo]

[P50:P450] = [IFERROR(P50:P450/R50:R450*12,0)]

Or perhaps :

[P50:P450] = [IFERROR(P50:P450/R50:R450*12,P50:P450)]

 

[ohFice]

I was able to utilize the second line of code you sent with a minor adjustment, see below.
[P50:P450] = [IFERROR(P50:P450/R50:R450*12,P50:P450)]
Thanks, Footoo!