I need some code to do a database lookup for each cell in specific cell range
that is not emply (e.g. a2-a250) and return a single record from the database
with a select using the value in that cell in the where clause.

I'm thinking the sql will be something like: "select jobname from jobs where
jobid = " (i don't know how to put in the cell reference, or the vb code
around it)

Can someone help me?