Setting a cell range then hiding rows with a certain value.

[JamesGilchrist]

Hi All,

Am working Excel 07/Vista and looking for a macro that will.....

1. Find the last populated cell in column A and set a range eg A3:Ax
2. Then hide all rows for an adjacent range (Clolumn C3: Cx) that have the value "N" in them.

Regards
James

 

[Michael M]

Hi James and welcome to the Board
Why do you need to set the range A3:Ax
If you want to hide rows as requested simply use

Sub delrowz()
Dim r As Long, lr As Long
Application.ScreenUpdating = False
lr = Cells(Rows.Count, "A").End(xlUp).Row
    For r = lr To 3 Step -1
        If Range("C" & r).Value = "N" Then
            Rows(r).EntireRow.Hidden = True
        End If
    Next r
Application.ScreenUpdating = True
End Sub