code to change activecell

[neopolitan]

I am using a macro to input four different formulas into adjacent cells
(Ex: C2,D2,E2,F2). These cells will not always be the same depending
on the worksheet that is being acted on. I don't know how to move
right one column in the same row in VBA code using the previous active
cell as a reference point. Can someone give me a simple VBA expression
to do this? Thanks.

 

[Ron de Bruin]

Hi

You can use offset

Sub test()
ActiveCell.Offset(0, 1).Select
End Sub

 

[neopolitan]

Thanks, Ron. I figured it was fairly simple just couldn't find it in
any help menus.