View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Prem Prem is offline
external usenet poster
 
Posts: 45
Default using CountIf in VB

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