"Ron de Bruin" wrote ...

I know the sheet name and cell that i want to read into my recordset

Maybe usuful
http://www.rondebruin.nl/ado.htm

Ron,
I couldn't get your code to return a value from a single cell. I tried
"A2" and "A2:A2".

The code needs a little tweak, methinks (hint: HDR=NO).

Jamie

--