By having Dynamic Range names set and Clearing Contents of all the Worksheet
i.e. A:IV does this effect the Offset feature that is coded within these
Dynamic Range Names? I'm getting errors when I clear ALL the worksheet that
the Dynamic Range name is in

I am using Debra Dalgleish example at
http://www.contextures.com/xlNames01.html#Dynamic


Thanks