Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
modify cell references in a formula programatically
First time post and new to Excel VBA. Using win98/xl97.
I have a spreadsheet that requires a set of similar formulae. The need to be replicated multiple times. Each formula is identical except the logical value cell reference in the IF function i incremented by 1 and the reference to the lookup value cells in th VLOOKUP functions is incremented by 6. Like this: A =IF(sheet1!C1="R",VLOOKUP(cand!C1,reps,3,FALSE),VL OOKUP(cand!C1,dems,3,FALSE)) =IF(sheet1!C2="R",VLOOKUP(cand!C7,reps,3,FALSE),VL OOKUP(cand!C7,dems,3,FALSE)) =IF(sheet1!C3="R",VLOOKUP(cand!C13,reps,3,FALSE),V LOOKUP(cand!C13,dems,3,FALSE)) =IF(sheet1!C4="R",VLOOKUP(cand!C20,reps,3,FALSE),V LOOKUP(cand!C20,dems,3,FALSE)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
modify all formula references in multiple cells | Excel Discussion (Misc queries) | |||
How can I programatically move cell contents | Excel Discussion (Misc queries) | |||
Modify an existing Cell formula using VBA | Excel Discussion (Misc queries) | |||
can i access the cell colour programatically? eg if cell is blue | Excel Discussion (Misc queries) | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) |