"Jake Marx" wrote in message
...
Hi Mike,

Is the column "Code" a text-based column? If so, you may need to wrap the
value with single quotes:

"SELECT SourceName FROM tblSourceRef WHERE
Code='" & $P$11 & "'"

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com


Jake,

That was it. *Kicks self*

Thanks for the help, in less than 10 minutes at that!

Mike