You might like to take a look at a solution to another user's similar
problem. Use the Search forums facility and look for posts by Teeb. One
of his posts is entitled "Copy and Paste Help". You may be able to
modify the posted solution to do what you want.
--
PeterB
------------------------------------------------------------------------
PeterB's Profile:
http://www.excelforum.com/member.php...o&userid=20288
View this thread:
http://www.excelforum.com/showthread...hreadid=372430