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
    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

Initial Language
Visual Basic