Thread: Correct me if I'm wrong but...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_24_] Stephen[_24_] is offline
external usenet poster
  
Posts: 83
Default Correct me if I'm wrong but...
Shouldn't...

For i = 31 To 1000
If .Cells(i, 21).Value = "0" And .Cells(i, 22).Value = "0" Then
..Cells(i, 1).EntireRow.Hidden = True
End If
Next i

hide each row where the values for columns "U" ANd "V" equal zero?

Reply With QuoteReply With Quote