Copied vlookup vba to a new vba setup and it wont work.

[fvisions]

I have a vlookup code that is coping the vlookup to the last row for a worksheet. I have a second worksheet that I am setting up and this step is exactly the same so I copied and pasted it to my VBA code but the vlookup is stopping at the H2 & I2 cells and not copying the vlookup to the end of the data. I have been hours looking at this...What am I missing?

Dim LastRow As Long
   LastRow = Cells(Rows.Count, 2).End(xlUp).Row
    Range("H2").Select
    Application.CutCopyMode = False
    Application.CutCopyMode = False
    Range("h2:h" & LastRow).FormulaR1C1 = _
        "=VLOOKUP(RC[-7],'Exhibit Vlookup Table'!R4C3:R65C14,9,FALSE)"
    Range("h2:h" & LastRow).Value = Range("h2:h" & LastRow).Value
    Range("I2").Select
    Application.CutCopyMode = False
    Application.CutCopyMode = False
    Range("i2:i" & LastRow).FormulaR1C1 = _
        "=VLOOKUP(RC[-8],'Exhibit Vlookup Table'!R4C3:R65C14,12,FALSE)"
    Range("i2:i" & LastRow).Value = Range("i2:i" & LastRow).Value
Columns("A:J").Select
    Columns("A:J").EntireColumn.AutoFit
    Range("A1").Select

 

[Fluff]

Do you have any data in col B?

 

[fvisions]

yes, below is a same of the full worksheet.

Contract Account	Business Partner	Pole	Road Code	Road Name	Operand	Remove	Install	LED Cost	Electricity +/-
number	TWN OF GREAT	20	401	BENNETTS COVE ROAD	MLHPCS070	SL HPS70W CUTOFF	26 Watt LED	9.1​
number	TWN OF GREAT	20	415	COTTAGE ROAD	MLHPCS070	SL HPS70W CUTOFF
number	TWN OF GREAT	113	481	SOUTH ROAD	MLHPCS070	SL HPS70W CUTOFF
number	TWN OF GREAT	4	412	CENTRAL AVENUE	MLHPCS070	SL HPS70W CUTOFF
number	TWN OF GREAT	2.1	480	SCHOOL HOUSE ROAD	MLHPCS070	SL HPS70W CUTOFF
number	TWN OF GREAT	18	460	NORTH ROAD	MLHPCS070	SL HPS70W CUTOFF
number	TWN OF GREAT	3	483	STONE WHARF ROAD	MLHPCS070	SL HPS70W CUTOFF

 

[Fluff]

In that case there should not be a problem, do you have any code after that?