I suspect that you just add more data variables.....but I'll let the GENIUS
give you the "absolute" answer.
Nigel, I'd love to give you credit in the Macro...anything you want me to
put up top for you?

David...and THANKS AGAIN!

"EMoe" wrote:


Hello,

I tried this code myself, and it works. This is alot of code for just
one cell.

How do you add to this one to include other cells values? Maybe you
want to to transfer 10 or 20 pieces of data.

Thanks,
EMoe


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=374992