I am getting an error message when I try that. But it does work for the next line that selects the range. Also I will need to change both the "A" part and the "2" part. I was thinking instead of having two input boxes to capture each of these values. Is there a way to trim off the numeric value from a valiable, or the alfebetic value of a variable. What I am thinking is taking the variable vRange (which equals B1). Now trimming it both ways creating two new variables call vRangeA (which equals B)) and vRangeN (which equals 1).
Here is the code I am using...
'Find matching item numbers on the Lookup_Table Tab
ActiveCell.FormulaR1C1 = "=VLOOKUP(TRIM(RC[" & colOffset & "]),Lookup_Table!R1C1:R" & sLTLastRow & "C2,2,0)"
'Getting Error Message On This Line
Selection.AutoFill Destination:=Cells(vRange2 & 2 & ":" & vRange2 + sLastRow)
'This Line Works OK Though
Range(vRange2 & 2 & ":" & vRange2 + sLastRow).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _