I am having a problem inserting this formula into the range specified here below;
Code: Select all
Range("$A$5").FormulaR1C1 = "=VLOOKUP(RngVal,Table2,2,FALSE)""
You help is appreciated.
Chuck
Code: Select all
Range("$A$5").FormulaR1C1 = "=VLOOKUP(RngVal,Table2,2,FALSE)""
Code: Select all
Range("$A$5").FormulaR1C1 = "=VLOOKUP=(RngVal,Table2,2,FALSE)"
Code: Select all
Range("$A$5").FormulaR1C1 = "=VLOOKUP(sheetName,Table2,2,FALSE)"
Code: Select all
Range("$A$5").Formula = "=VLOOKUP(" & RngVal & ",Table2,2,FALSE)"
Code: Select all
Range("$A$5").Formula = "=VLOOKUP(" & """" & sheetName & """" & ",Table2,2,FALSE)"
Code: Select all
Range("$A$5").Formula = "=VLOOKUP(" & sheetName & ",Table2,2,FALSE)"
Code: Select all
?Range("$A$5").Formula
=VLOOKUP(AAC,Table2,2,FALSE)
Code: Select all
Range("$A$5").Formula = "=VLOOKUP(" & """ & sheetName & """ & ",Table2,2,FALSE)"