The other thing I noticed was that your error handler was inside your Do/Loop
loop. It has to be outside of that loop, and the Resume statement should send
it back into a statement inside the loop.


On Wed, 11 May 2005 13:26:35 -0400, Kate wrote:

Thank you, I didn't understand that. Now it works!

Chip Pearson wrote:
You need to understand how error handling works. When an error is
raised, your code goes to err_do, and VBA is running in "error
mode". No other errors can be trapped until you exit error mode
and go back in to normal mode. This is done with a Resume, Resume
Next, Exit Sub, or End Sub statement.