Return to Snippet

Revision: 4957
at January 31, 2008 04:18 by neozhang


Initial Code
Dim t as Long

If Application.IsNA(Application.VLookup(item, rng1, 10, 0)) Then
    t = 0
Else
    t = ActiveCell.Offset(0, 51).Value
End If

# use t instead of the cell value in the following calculation

Initial URL


Initial Description


Initial Title
Avoid #N/A to Cause "Type Mismatch"

Initial Tags
excel

Initial Language
Visual Basic