Hiding cells within my range

[tgick]

I have a spreadsheet wherein I want to hide all rows in a set range if the the value in that row, column Y = "HIDE".

Below is the code I have written. I have a command just before this which sets My Range, depending on the value of a certain cell. Can anyone tell me why this does not work?

If MyRange.Address <> "$A$1" Then
For Each Cell In MyRange
Rows(Cell.Row).Hidden = UCase(Cell.Value) = "HIDE"
Next Cell
End If

 

[schielrn]

Maybe try:

If MyRange.Address <> "$A$1" Then
For Each Cell In MyRange
Cell.entireRow.Hidden = (UCase(Cell.Value) = "HIDE")
Next Cell
End If

Hope that helps.

 

[tgick]

Nope, that didn't do it.

Any other suggestions?

 

[schielrn]

MyRange.Address is porbably not going to = $A$1 ever as hopefully since you are using a for loop MyRange is more than one cell. But that wouldn't effect the outcome. Can you post the whole code? Maybe try putting in a breakpoint and seeing what the value of cell is at each point in the code and walk through the code using F8?