Backwards compatibility issue between VB Excel 2010 -> 2003

Steve

Are you sure this is a version issue?

I can't see anything in the code that is version specific.

I think the problem might be with FirstCol/FirstRow/LastCol/LastRow.

FirstCol and LastCol should be column letters.

Also, in a cell reference the column comes first then the row.

Perhaps you could use Cells?

.Range("H2:H" & pRow).Formula = "=VLOOKUP(A2,All_Parts!" & Cells(FirstRow, FirstCol).Address & ":" & Cells(LastRow, LastCol).Address & ",2,FALSE)"