How does the VBA IsMissing function work under the hood?
See the question and my original answer on StackOverflowThe "missing" variant is a VARIANT with the vt member (VARTYPE) set to VT_ERROR and the scode member set to DISP_E_PARAMNOTFOUND (0x80020004).