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
|