code to change activecell
 

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

code to change activecell
 

Hi

You can use offset

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"neopolitan" wrote in message ...
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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

code to change activecell
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/