Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |