VBA:在 Vlookup 中使用 Dims

Question

我正在尝试在 VBA 中进行 vlookup，我得到了 Application-defined or object-defined error运行时错误。

我用整数和字符串而不是 Dims 重写了该行它工作正常，但我需要让它可变。

'Throws Error
rc = -6
tempwb = "Supplier Master - Location - 08-13-15.xls"
acol = 1
zcol = 14
wRange.FormulaR1C1 = "=VLOOKUP(RC[rc],'[" & tempwb & "]Sheet1'!C" & acol & ":C" & zcol & "," & ((zcol - acol) + 1) & ",FALSE)"


'Works
wRange.FormulaR1C1 = "=Vlookup(RC[-6],'[Supplier Master - Location - 08-13-15.xls]Sheet1'!C1:C14,14,FALSE)"

Answer 1

尝试改变

wRange.FormulaR1C1 = "=VLOOKUP(RC[rc],

成为

wRange.FormulaR1C1 = "=VLOOKUP(RC[" & rc & "],

完毕？