How does PKG get changed?

Manually or by formula?

You could use sheet event code which runs automatically off the PKG value
when it is manually changed.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Me.Range("PKG")) Is Nothing Then
If Target.Value = "bulk" Then
Me.Range("A187:A195").EntireRow.Hidden = True
Else
Me.Range("A187:A195").EntireRow.Hidden = False
End If
End If
End Sub


Gord Dibben MS Excel MVP



On Wed, 10 Dec 2008 11:57:01 -0800, rwinter
wrote:

I would like to be able to automatically hide rows based on the value of a
particular cell in the same worksheet. I think that I should be able to do
this with a macro, but I have no experience writing my own macros, and need
thorough instructions for how to create/use a macros.

Here are some details about my excel 2003 spreadsheet: Close to the
beginning of the worksheet, there is a cell named PKG, this cell either gets
the value of "Pack of 1" or "Bulk". When PKG="Bulk", I would like rows
187-195 to be hidden, but I would like them to be displayed when PKG="Pack of
1". Could somebody please walk me through this?

Thanks!