Solved: Summary Of Error Descriptions...

[Wolfgang]

Good Morning All,

Is there something like a catalog or summary that lists all Excel error codes and their descriptions?!

Thank you...

Best,
Wolfgang

[Ivan F Moala]

VBA Help search

Trappable Errors

[Wolfgang]

Thank you very much Ivan,

but where is the explanation of error code 1004?!

Best,
Wolfgang

[Cyberdude]

I think that's just a general run time error. You might try something like:
If Err = 1004 Then Msgbox Err.Description

[malik641]

Thank you very much Ivan,

but where is the explanation of error code 1004?!

Best,
Wolfgang

From the immediate window:


?Error(1004)
Application-defined or object-defined error

And I couldn't really find anything useful on MSDN or Help....

Could you show us your code with the error and where the error arises?

[Wolfgang]

Good Morning Gentlemen and thank you very much for your ideas...

A friend called me this week asking me if I know anything about error codes and their meanings.

Apparently, he has some code running, which caused that error, and he claims that he got two explanations for the same error…

He got himself very confused about that and deleted his macro…Ah well…

I will mark this thread solved since he is not of great help finding the “root cause” of this funny behaviour…

Have a nice day all of you…

Best,
Wolfgang