I have a large file with a vba code that does several things. One being a vlookup from a column. The vlookup results are #N/A due to the lookup value needing to be converted to a number. How do I update the code to go to column i and convert the full column to a number?
Dim LastRow As Long LastRow = Cells(Rows.Count, 2).End(xlUp).Row Range("K2").Select Application.CutCopyMode = False Application.CutCopyMode = False Range("K2:K" & LastRow).FormulaR1C1 = "=VLOOKUP(RC[-2],'Plant and Status List'!R3C5:R1071C8,4,FALSE)" Range("K2:K" & LastRow).Value = Range("K2:K" & LastRow).Value Range("K1").Select