Checking for #N/A in Excel cell from VBA code

by

First check for an error (N/A value) and then try the comparisation against cvErr(). You are comparing two different things, a value and an error. This may work, but not always. Simply casting the expression to an error may result in similar problems because it is not a real error only the value of an error which depends on the expression.

If IsError(ActiveWorkbook.Sheets("Publish").Range("G4").offset(offsetCount, 0).Value) Then
  If (ActiveWorkbook.Sheets("Publish").Range("G4").offset(offsetCount, 0).Value <> CVErr(xlErrNA)) Then
    'do something
  End If
End If

More Related Contents:

  1. Print function selecting wrong Type of Change option excel vba
  2. What is the difference between .text, .value, and .value2?
  3. Excel VBA – How to add dynamic array formula
  4. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  5. Check if the file exists using VBA
  6. Loading addins when Excel is instantiated programmatically
  7. Trying to use variables as values vba to sql
  8. How to call a macro from a button and pass arguments
  9. Copy Excel range as Picture to Outlook
  10. VBA (Excel) Dictionary on Mac?
  11. Return RGB values from Range.Interior.Color (or any other Color Property)
  12. Refresh Excel VBA Function Results
  13. excel VBA run macro automatically whenever a cell is changed
  14. Code for looping through all excel files in a specified folder, and pulling data from specific cells
  15. Translate text using vba
  16. Concatenate column headers if value in rows below is non-blank
  17. Update excel sheet based on outlook mail [closed]
  18. Copy sheet and get resulting sheet object?
  19. Sending mail using Outlook where the Send method fails
  20. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  21. Using a variable for row in (row,column) for a range in VBA
  22. Unicode string literals in VBA
  23. How to get the path of current worksheet in VBA?
  24. How to open a workbook specifying its path
  25. Application.WorksheetFunction.Match method
  26. Delete all data rows from an Excel table (apart from the first)
  27. Excel Hide/Show all tabs on Ribbon except custom tab
  28. Macros Not Showing Up in Macro Table
  29. Excel telling me my blank cells aren’t blank
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment