aaronward
Board Regular
- Joined
- Aug 2, 2006
- Messages
- 165
ok, i have now moved to a match routine. Heres my code and data:
Column G:
1
3
5
7
9
i have manipulated the function to return true/false for IsNA, IsError, IsNumber. i have made sure my full range is declared as 'Number" with no decimal places. The results can never find where it does not match. ANY SUGGESTIONS is greatly appreciated! Thanks!
Column G:
1
3
5
7
9
Code:
Dim r as Byte, Results as Boolean
For r = 1 To 10
Results = Application.WorksheetFunction.IsNA(Application.WorksheetFunction.Match(r, Range("G4:G20"), 1))
If Results Then
MsgBox "No Match" & vbCr & r
Else
MsgBox "Matches" & vbCr & r
End If
Next r
i have manipulated the function to return true/false for IsNA, IsError, IsNumber. i have made sure my full range is declared as 'Number" with no decimal places. The results can never find where it does not match. ANY SUGGESTIONS is greatly appreciated! Thanks!