Handling Errors from Formula result, stored in a variable.

I have looked long for this, but i havent found a truly similar post on web in 2 hours. (so now im posting it on 3 forums)

Scenario:

Please Login or Register  to view this content.

---
Now if i check the values of -Result- it can either be a number or an error.:
Debug.Print Result -> 1
Debug.Print result -> Error 2042

---
I can test -Result- with: IsError(result) and it gives True or False
... but even if -Result- IS an error, I cannot get its number.

Result.Number -> Object or Type error message comes
so seemingly i cannot use it as in Err.Number

How can I get the error number of -Result- variable?
What is in this case -Result- really equal with?

If i say If Result = ??? Then ... when will it be true if i know that its Error 2042?
I have tested Case "Error 2042" ; Case Err ; Case Error ; Case Err(2042) ; ...
None of these showed True for -Result- when it debug.printed Error 2042

Please enlighten me guys.

I got the answer here: https://stackoverflow.com/a/48128024