Avoid #N/A to Cause "Type Mismatch"


/ Published in: Visual Basic
Save to your folder(s)



Copy this code and paste it in your HTML
  1. Dim t as Long
  2.  
  3. If Application.IsNA(Application.VLookup(item, rng1, 10, 0)) Then
  4. t = 0
  5. Else
  6. t = ActiveCell.Offset(0, 51).Value
  7. End If
  8.  
  9. # use t instead of the cell value in the following calculation

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.