Hi Howard,

Am Mon, 26 Oct 2015 04:19:08 -0700 (PDT) schrieb L. Howard:

With only Name 1, Name 2 etc. in column 1, it seems one could then pass that AR to a sheet name some how, since each is also a sheet name.

I guess if you have the name in the first cell in column A and also in
the last cell in column E the code in Module2 is the easiest one.
If there is no name in column E or the names can change in order the
code in Module3 is more reliable.


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