香港新浪網 MySinaBlog
« 上一篇 | 下一篇 »
Emily | 24th May 2006, 17:21 PM | General | (1508 Reads)

"#N/A" , "#value!" 在代碼中如何表示

Error number (Constant)   Literal error value     Converted error value
-----------------------------------------------------------------------

xlErrDiv0                   [#DIV/0!]               CVErr(xlErrDiv0)
xlErrNA                     [#N/A]                  CVErr(xlErrNA)
xlErrName                   [#NAME?]                CVErr(xlErrName)
xlErrNull                   [#NULL!]                CVErr(xlErrNull)
xlErrNum                    [#NUM!]                 CVErr(xlErrNum)
xlErrRef                    [#REF!]                 CVErr(xlErrRef)
xlErrValue                  [#VALUE!]
CVErr(xlErrValue)

 

 More Details: Error Trapping with Visual Basic for Applications