Hello,

Sorry to raise this issue again, but I'm still having trouble using the IS
functions, here's the latest manifestation (running Excel 97)

This formula works perfectly fine in my spreadsheet:

=IF( ISNA(MATCH(0,A1:H1,0)),"Zero NOT found","Zero found")

However, a similar statement in VBA code generates an error message if '0'
is not present (e.g., N/A), but works if '0' is present.

Set rng = Range("A1:H1")
If WorksheetFunction.IsNA(WorksheetFunction.Match(0, rng, 0)) Then
MsgBox "Zero NOT found": Exit Sub
Else
MsgBox "Zero found"
End If

Here's the error message:

Run-time error '1004':
Unable to get the Match property of the WorksheetFunction class.

Am I doing something wrong - can't seem to spot it? Appreciate any
suggestions.

Thanks,

Dave