this is something i've already asked yesterday on the access forums:
http://www.accessforums.net/showthread.php?t=72952
I have the code working and it does paste how i want but there are formatting issues.
I need "Paste options: merge" in VBA code. If that is possible please let me know. Thank you.
Andy