Hi

What you mean by "an error debug message "
In case of an error, excel will create the appropiate message itself.

But probably you don't want that message, but rather one you create yourself. That's called error handling, and can become quite tricky. Usually you should write the code the way to avoid errors taking in consideration which errors possibly might come up during runtime.