These are absolute gems. I greatly appreciate your very fast help. I've already
begun to
change some of my macros  at work today. Almost thought I'd lost my file today
due to a
power outage. The IT guy told me I'd have to start from scratch, which meant I'd
lose ALL
my macros and named  ranges. Oh my! it was almost a melt down moment since I'm
the only
person in my office trying to use VB to make most of my Excel reporting more
efficient. Even
very simple  macros makes some tedious tasks tolerable.