macro to hide a row when a cell contains a value

External Since: Nov 17, 2008 Posts: 1

I have an excel sheet that contains multiple rows. I want to be able to
hide/unhide the rows that contain "C" (complete) when there is a "C" in
column P when I click on the command button that contains the macro

External Since: Oct 01, 2005 Posts: 3613

Sub HideMe()
n = Cells(Rows.Count, "P").End(xlUp).Row
For i = 1 To n
If Cells(i, "P").Value = "C" Then
Rows(i).EntireRow.Hidden = True
End If
Next
End Sub

--
Gary''s Student - gsnu200814

"InfoNeeded" wrote:

> I have an excel sheet that contains multiple rows. I want to be able to
> hide/unhide the rows that contain "C" (complete) when there is a "C" in
> column P when I click on the command button that contains the macro