Results 1 to 2 of 2

Thread: #N/A error?

  1. #1
    Join Date
    Oct 2003

    Unanswered: #N/A error?

    i copied a formula and pasted the values. Some of them will not calc and wil return :#N/A

    I would like to go cell by cell (all in 1 colm) searching for this condition.
    how can i do that in vba?


  2. #2
    Join Date
    Dec 2003
    San Diego, CA
    From the helpfile:
    Cell Error Values Example

    This example inserts the seven cell error values into cells A1:A7 on Sheet1.

    myArray = Array(xlErrDiv0, xlErrNA, xlErrName, xlErrNull, _
    xlErrNum, xlErrRef, xlErrValue)
    For i = 1 To 7
    Worksheets("Sheet1").Cells(i, 1).Value = CVErr(myArray(i - 1))
    Next i
    This example displays a message if the active cell on Sheet1 contains a cell error value. You can use this example as a framework for a cell-error-value error handler.

    If IsError(ActiveCell.Value) Then
    errval = ActiveCell.Value
    Select Case errval
    Case CVErr(xlErrDiv0)
    MsgBox "#DIV/0! error"
    Case CVErr(xlErrNA)
    MsgBox "#N/A error"
    Case CVErr(xlErrName)
    MsgBox "#NAME? error"
    Case CVErr(xlErrNull)
    MsgBox "#NULL! error"
    Case CVErr(xlErrNum)
    MsgBox "#NUM! error"
    Case CVErr(xlErrRef)
    MsgBox "#REF! error"
    Case CVErr(xlErrValue)
    MsgBox "#VALUE! error"
    Case Else
    MsgBox "This should never happen!!"
    End Select
    End If
    Hope that helps,


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts