cww

Try here, mid way down page

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"cww" wrote in message
...
Any way to pass selection itemd from a CELL into an attached/ embedded MS
Qry
withou invoking and editing the Qry??