I was attempting to insert the the following formula "=vloopup(A14,Powers,2,FALSE)" into a known number of cells where the "A14" is relative and the active cell is incremented by the for value x.
Compile Error: Invalid or unqualified reference
Thanks for the heads up' Place the lookup formulas Set swSheetBC = ActiveSheet Range("V14").Select For x = 1 To inCnt - 1 .cell(x, 0).Formula = "=VLOOKUP(" & _ .Offset(0, -21).Address(0, 0) & _ ",Powers,2,FALSE)" Next
Bookmarks