I will name my first-born after you.

Seeing the "MoveFirst" triggered the realization for me-- my old
..GetRows() method was still interlaced with my new code. I major
'doh!' moment for me. I somehow omitted it from the post of my code
here.

Thanks both of you Tim and onedaywhen.

I don't know when it would've hit me that was the issue if I had not
have had your input.

-- emil


(onedaywhen) wrote in message . com...
You would get the result you described (i.e. a blank range and no
error ) if the recordset is EOF = True, e.g. you have already used
CopyFromRecordset and not moved issued a MoveFirst or your recordset
contains zero rows (perhaps due to a filter). However, there's nothing
in your code to suggest this so if you didn't snip and didn't do
anything in the Immediate Window before the CopyFromRecordset then I'm
stumped.

--