Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fixing table array in vlookup?
Chris,
2 things - you can skip the auto fill by using Range("B1:B626").FormulaR1C1= Second - just replace [1] & [25555] with numbers (the brackets are the same as removing the $ symbols and make the references relative instead of absolute) I think in your case that would be R2C1:R25556C2 If the rows and columns are not predetermined, than set new variables for them. The CONTATENATE part confuses me. steve "Chris H" wrote in message ... Hello, I have this code within a VBA macro: ActiveCell.FormulaR1C1 = _ "=VLOOKUP(CONCATENATE(" & i & ",""_"",RC[-1]),'in data'!R[1]C[-1]:R[2555]C,2,FALSE)" Selection.AutoFill Destination:=Range("B1:B626"), Type:=xlFillDefault How do I fix the table array ('in data'!R[1]C[-1]:R[2555]C) to remain constant during the AutoFill? (In a formula the row and column references would be preceded with $). Many thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup Using a Reference as a Table Array | Excel Worksheet Functions | |||
Vlookup-table array runs? | Excel Worksheet Functions | |||
array table and vlookup | Excel Worksheet Functions | |||
vlookup - can't pick up table array | Excel Worksheet Functions | |||
VLOOKUP - 3 Table Array | Excel Worksheet Functions |