"Frank Kabel" wrote in message
...
Hi
you may also make the following change to Bob's (excellent) procedu
Move the line
.Columns("A:D").EntireColumn.AutoFit
directly after the For - Next loop to ensure the autofitting of columns
A-D

Thanks, didn't spot that, just added it at the end after testing to save the
OP having to do it manually (when will I ever learn?).



To Bob: Hope you didn't mind I changed your code <vbg



Absolutely not Frank, it is not only helpful, you might do something I would
not have thought of, so all benefit. It's a co-operative here, part of it's
richness, and I am not averse to adding my bit to other's postings. I was
unavailable for the past 2 hours anyway, had to make some flapjacks