Hi Howard,

Am Tue, 28 Apr 2015 08:48:46 -0700 (PDT) schrieb L. Howard:

Hmmm, I am thinking you may have mistaken what the code needs to do. It looks like it formats the VBA and CF sheets assuming those two sheets already are constructed as you show.

CF and the code are looking in Sheet1. If the range in sheet1 you have
to enlarge the named ranges. The code always uses the correct ranges.


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