Solved: Supressing '#N/A' in WorksheetFunction.VLookup

[Cosmo]

You can test to find the error vaslue and handle it accordingly

[vba]

On Error Resume Next
rngDestination = WorksheetFunction.VLookup(rngLookup, rngSource, i, 0)
MsgBox Err
If Err = 1004 Then
MsgBox "Problem"
Exit Sub
Else
On Error GoTo 0
End If

MsgBox rngDestination


[/vba]

Thanks, but the rngDestination is an entire range spanning multiple rows, not a single value, so I'm not getting an error with this (I'm guessing the error returned is for the last row processed, which has a matching value?).