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
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