View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
saziz[_82_] saziz[_82_] is offline
external usenet poster
 
Posts: 1
Default countif (2) conditions


Hi,
I am trying to give 2 conditions in the following line in my code it
doesn't
work. Can someone help me with the syntax please?
If I give one condition (high or low) it works. But I need to save both
high & low.


If Application.WorksheetFunction.CountIf(.Rows(Lrow), "High" And
"Low") = 0 Then .Rows(Lrow).Delete



Thank you
Saziz


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=573964