Hi Howard,

Am Fri, 14 Aug 2015 03:34:58 -0700 (PDT) schrieb L. Howard:

I added some lines to do additional stuff.

Do you see any glaring errors? It does exactly what I want it to do, but may not be best coding practices.

no, every thing is okay.

But delete [D6].Activate at the end of the code
It's not good practice and also superfluous.

If you want go back to D6 then try it with
Application.Goto range("D6")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional