using CountIf in VB
It must depend upon what you have in rs1.Fields(0).Value.
But using Cells is not a good idea, checking over 16M cells is a tad
wasteful.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Prem" wrote in message
...
When i am using the following line of code in my VB6.0 Program
"If WorksheetFunction.CountIf(Cells, rs1.Fields(0).Value) = 0 Then"
the application always throws the following Error message which is not
understable
"Method '~' of object '~' failed"
Can anyone throw some light on this issue.
--
Premkumar
|