Here is my code and I am also linking this to a thread that directly helped me 



Private Sub Worksheet_Calculate()

Application.ScreenUpdating = False

Dim rngCell As Range

For Each rngCell In Range("B178:B188")
  rngCell.EntireRow.Hidden = rngCell.Value = 0
Next rngCell

Application.ScreenUpdating = True

End Sub

The main problem here is the fact that I believe this macro is calculating line by line regardless of whether or not there is an actual change in the cell range. Is there a way (and I am brand new to VBA so be gentle) to set up a condition that will search out the actually changed (affected) cell(s) instead of a wholesale assumption? Thanks in advance for any help my way.


p.s. I should note that I am posting this because my spreadsheet hangs then crashes at present.




http://www.excelforum.com/excel-prog...ls-g1-lg1.html