vbObjectError Not Working as Expected

[johnywhy]

you don't seem to be using a class module

Let's assume i am.

My reading of the spec is that vbObjectError isn't required for modules, not that it's forbidden. Do you think i may overlap native numbers if i used vbObjectError for custom errors in modules?

Since 746 (attachment) seems to be the highest system error number used, I'd just keep my errors between 1000 and 9999. Anything below is Excel's, anything between is my custom

maybe, but i don't feel that's reliable. Also, i think the unsigned-int nature of error numbers may be relevant.

Hoping to find an algorithm based on vbObjectError, rather than a hardcoded range.

thx!