You can use err.Description to get a (short) text version of the error.

Tim

"Rookie_User" wrote in message ...
Does anyone have a function or some code that contains the most common errors
so that when we create new macro's we can use a function or something when an
error happens it pulls up the correct description of the error? I am not
very good at this so if you have any other idea's please let me know.