'=IF($AA3<> " ",VLOOKUP(ABS($AA3),'C:\Reference\[TranMaster.xls]Translator'!$A$11:$AC$54,2,TRUE)," ")

The above VLookUp statement runs great when its in a cell.

In a macro it won't compile. At the ' in front of 'C:\Reference\... the compiler says "Expected Expression."

Below is what is actually crashing

===============
If (sBreakDown <> " ") Then
sDistrict = Application.VLOOKUP(ActiveSheet.Cells(i,1),'C:\Reference\[TranMaster.xls]Translator'!$A$11:$AC$54,2,TRUE)," ")
End If
===============

Thanks for helping..Too many hours, not enough sleep! Craigm