Advanced Search

Avoid #N/A to Cause "Type Mismatch"

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

Expand | Embed | Plain Text

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.