"Bill Burns" wrote in message
...

Bob,
Thanks so much! It works great.

I gave you the wrong cell range in my initial post. The range I gave you
was
"Range("K3:D55") and it should have been "Range("K3:DE55")" . I modified
your code (see below). Thank You!

LOL!. Because the range was backwards (K3:D55), that was why I introduced
the double-loop. If you had given me the right one, I would have maintained
the single loop, and that would have populated the cells in the order K3,
L3, M3, N3, rather thatn K3, K4, K45, etc.

Serendipity or what?

Bob