Error Handling - Excel VBA [RESOLVED]

[Mitch_s_s]

What i want to be able to do is the following:

i want be able to extract the line of code that is running that cause the error

e.g if you had on line 32
average = 32/0

this statement would give you an error, is there anyway i could extract this line number.
What i then want to do is to display a message box saying
"Please contact your administrator quoting L32 and " & Err

where L32 is the line number, and Err is obviously the error number.

Thanks
Mitch