Hi Ken,

The 'On Error Statement' help explains, much better than I could, why I
had to re-jig the error handling.

Cheers
Andy

Ken Johnson wrote:
Hi Andy,

that is absolutely fantastic!

Correct me if I'm wrong (I usual am)...

It looks to me like the solution involves removing the treatment of the
error from the inside of the loop. I wasn't aware of the need for
Resume Next, I had hoped that On Error GoTo could be repeatedly used
inside the loop.

Anyway, I still a bit confused, but excited that it now works.

Thanks again Andy.

Ken Johnson


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info