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!

Be Glad Too...
It would look Somthing like this

Sub Marine()
If Range("PKG").Value = "Bulk" Then
Range("A187:A195").EntireRow.Hidden = True
Else
Range("A187-195").Hidden = True
End If
End Sub

"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!

I really should read these first here is the right one

Sub Marine()
If Range("PKG").Value = "Bulk" Then
Range("A187:A195").EntireRow.Hidden = True
Else
Range("A187:A195").EntireRow.Hidden = False
End If
End Sub

Post back w/ any questions

"Office_Novice" wrote:

> Be Glad Too...
> It would look Somthing like this
>
> Sub Marine()
> If Range("PKG").Value = "Bulk" Then
> Range("A187:A195").EntireRow.Hidden = True
> Else
> Range("A187-195").Hidden = True
> End If
> End Sub
>
> "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!

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
<(E-Mail Removed)> 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!