On Tuesday, April 28, 2015 at 8:58:19 AM UTC-7, Claus Busch wrote:
Hi Howard,

Am Tue, 28 Apr 2015 17:53:42 +0200 schrieb Claus Busch:

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.

I changed the formulas for the named ranges. They now are adapted to the
correct range.


Regards
Claus B.

The code needs to assume that CF and VBA are blank sheets to start, and must be created by the code from the huge sheet 1 layout.

Howard