Hi,
I have this variable to open up the file path in C6 in MAIN tab.
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.
Range("X13").Select...