convert the if statements to OR conditions

[nynamyna]

Hello everybody,

I have the following if conditions which I have to convert into OR statements in a simple way. That is, if either one of this condition is true then the variable count should be updated (count =count +1)
<!-- BEGIN TEMPLATE: bbcode_code -->

lastrow = Sheets(2).UsedRange.Rows.count
For icell = 2 To lastrow
    If (Sheets(2).Range("B" & icell).Value <> Sheets(2).Range("B" & (icell - 1)).Value) Then
 
  If (Sheets(2).Range("P" & icell).Value <> Sheets(2).Range("P" & (icell - 1)).Value) Then
 
    If (Sheets(2).Range("R" & icell).Value <> Sheets(2).Range("R" & (icell - 1)).Value) Then
 
     if (Sheets(2).Range("T" & icell).Value <> Sheets(2).Range("T" & (icell - 1)).Value) Then
 
     If (Sheets(2).Range("U" & icell).Value <> Sheets(2).Range("U" & (icell - 1)).Value) Then
 
     If (Sheets(2).Range("V" & icell).Value <> Sheets(2).Range("V" & (icell - 1)).Value) Then
 
 count = count +1
 
Next icell

Thanks,
Vijay

 

[MrKowz]

Something like this?

With Sheets(2)
    lastrow = .UsedRange.Rows.Count
    For icell = 2 To lastrow
        If (.Range("B" & icell).Value <> .Range("B" & (icell - 1)).Value) Or _
           (.Range("P" & icell).Value <> .Range("P" & (icell - 1)).Value) Or _
           (.Range("R" & icell).Value <> .Range("R" & (icell - 1)).Value) Or _
           (.Range("T" & icell).Value <> .Range("T" & (icell - 1)).Value) Or _
           (.Range("U" & icell).Value <> .Range("U" & (icell - 1)).Value) Or _
           (.Range("V" & icell).Value <> .Range("V" & (icell - 1)).Value) Then
     
            Count = Count + 1
        End If
    Next icell
End With

 

[nynamyna]

yes...is this the final code ?

 

[MrKowz]

yes...is this the final code ?

It is the final code based on what you supplied. I also cleaned it up by adding a With statement.

 

[nynamyna]

got it..thanks..this is what I want