View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] todd.huttenstine@charter.net is offline
external usenet poster
 
Posts: 17
Default OR clause doesn't execute the last condition

Maybe try to repeat your testing condition like:

If .Cells(iRow, ServiceGroupColumn).Value < _
.Cells(iRow - 1, ServiceGroupColumn).Value Or _
If .Cells(iRow, ServiceGroupColumn).Value < (iRow =
(FirstDataRow - 1)) Then