Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Relative reference in VB with If Then
Since this is occuring in thousands of rows I would like to automate it with
a macro and leave the formula in a cell that can be modified (if need be) by the user. So, say it looks like this: For x = 21 To 2500 If Cells(x, 6) Cells(19,6) Then Cells(x, 15).Formula = Cells(19,15).Formula flag = 1 End If The formula in row19 column15 is this: =IF(AC190,0,IF(D19<" ",IF(B19="X",VLOOKUP(D19,'2006 IP Template'!B:C,2,FALSE),IF(D19<" ",IF(B19="y",VLOOKUP(D19,'2006 IP Template'!B:C,2,FALSE),IF(D19<" ",IF(B19="Z",VLOOKUP(D19,'2006 IP Template'!B:C,2,)))))))) My PROBLEM is I don't know how to make this formula copy down the rows as a RELATIVE CELL REFERENCE. What code would make this formula change to refer to row 21 and so on as it gets pasted down? Your help is most appreciated! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Reference help | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
relative reference | Excel Discussion (Misc queries) | |||
Relative Reference | Excel Discussion (Misc queries) | |||
relative reference | New Users to Excel |