On Tuesday, July 16, 2013 1:03:30 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Tue, 16 Jul 2013 00:59:33 -0700 (PDT) schrieb Howard:



Much cleaner.



but does it work?





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Yes, indeed, works fine. However, it had a subscript out of range error and that lead me to investigate and see that my original code was actually working except I have Book2 as the copy TO and It should have been Book3.

So it would copy back to the same sheet as the copy FROM, while all the time I was looking at book3 for the results and not getting any.

You can fix code, but you can't fix stupid.<g

Thanks Claus.

Regards,
Howard