You can't do an Application.VLOOKUP on a closed workbook. Worksheet
function, yes, VBA, no.

--
HTH

Bob Phillips

"Craigm" wrote in
message ...

'=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:\Ref erence\[TranMaster.xls]Tra
nslator'!$A$11:$AC$54,2,TRUE),"
")
End If
===============

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


--
Craigm
------------------------------------------------------------------------
Craigm's Profile:
http://www.excelforum.com/member.php...o&userid=24381
View this thread: http://www.excelforum.com/showthread...hreadid=383822