Hiding Rows based on cell value

[Tcarr]

I need to hide rows A10:A109 if the value is greater than the cell value in G6

 

[herofox]

upload excel file ?!!!

 

[p45cal]

best upload a file so that you'll know what to do with:

For Each cll In Range("A10:A109").Cells
  If cll.Value > Range("G6").Value Then cll.EntireRow.Hidden = True
Next cll

 

[Tcarr]

Thanks, that worked! However, if the number in cell G6 changes, the adjustment does not update the range A10:A109.

 

[p45cal]

See attached

 

[Tcarr]

See attached

Thank you!!!

 

[Tcarr]

Thank you!!!

When I password protect the top section of my worksheet (password: gcadmin) it cause a runtime error 1004 - suggestions on how to fix?

 

[p45cal]

Unlock C2:C7
When protecting the sheet tick the Format rows box.

 

[Tcarr]

Unlock C2:C7
When protecting the sheet tick the Format rows box.

Thank you, that worked and I learned something new