Hi,
I have this variable to open up the file path in C6 in MAIN tab.
but I am trying to do lookup with variables, but it not working.
Here is what I wrote to make vlookup. Does any sees why this code is not working?
Any advises are welcome!
I have this variable to open up the file path in C6 in MAIN tab.
Code:
Dim TESTWB As Workbook: Dim dpath As String: dpath = Template.Worksheets("MAIN").Range("C6").Value
but I am trying to do lookup with variables, but it not working.
Code:
Range("X13").Select
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-7],&dpath&!C10:C38,29,FALSE)"
Here is what I wrote to make vlookup. Does any sees why this code is not working?
Any advises are welcome!