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