Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO EDIT CELL FORMULA !!
Please help. This thing is driving me nuts !! I need a macro that will paste an altered copy of a cell formula into another cell. Example - cell B10 contains ='SheetX'!K22 When I copy and paste its formula in any cell, say D6, cell D6 should contain='SheetX'!K23 Another example - say cell F4 contains='SheetX'!P10 When I copy and paste that formula in any cell, like J5, cell J5 should contain='SheetX'!P11 I have lots of cell formulas to change the row portion of their formulas just by 1 and doing this manually is painful and tedious. Please help with a code. Thanks in advance!! Jay Dean *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to edit formula in cell | Excel Discussion (Misc queries) | |||
Macro to edit formula | Excel Discussion (Misc queries) | |||
Macro to edit cell | Excel Programming | |||
macro to edit formula | Excel Programming | |||
macro to edit formula | Excel Programming |