Hiding Rows Marco

[Zach]

Ok I got a macro to work that hides columns based on cell color and now I'm trying to accomplish the same thing except I'm hiding rows. I'm basically trying to hide all the rows that have the cell color white (255,255,255) in column B.

     Dim cell As Range
  For Each cell In Range("B11:B122") 'Change range to suit
 If cell.Interior.Color = RGB(255, 255, 255) Then
  Rows(cell.Rows).EntireRow.Hidden = True
  End If
  Next
End Sub

But it keeps debugging and I can't figure out what is going on.

 

[NARAYANK991]

Hi ,

See your file now.

Narayan

 

[Zach]

Hi ,

See your file now.

Narayan

Hey I appreciate you looking it over and thanks for the update, it works like I need it to now.