Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell.FormulaR1C1 | Excel Discussion (Misc queries) | |||
ACTIVECELL LOCATION | Excel Discussion (Misc queries) | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
activecell & Vlookup | Excel Discussion (Misc queries) | |||
chart MAcro to change on activecell | Excel Discussion (Misc queries) |