Hiding rows when a cell within a named range is null

[azcat90]

I want to create a macro that will hide rows within 12 different ranges of cells on a worksheet.

All 12 ranges 20 rows each.

I can't figure our how to cycle through the cells in each range to test each cell to see if it is null.

 

[tmcfadden]

I'd suggest a "For each" loop structure.

For example,

For Each cell In Sheet1.Range("A1:A5")
    If (cell.Value = "") Then
        Sheet1.Range("A1:A5").Rows.Hidden = True
        Exit For
    End If
Next cell

-Tim

 

[azcat90]

This code worked

Tim: Your code pointed me in the right direction.

This is what worked:

Private Sub FINISH_EDIT_Click()

Dim myrg As Range
Dim opco As String

Rem Define a range of cells to be tested
opco = "EXP"
For j = 1 To 2
If j = 2 Then opco = "GRD"
For i = 1 To 6
Set myrg = Range(opco & i)

For Each cell In myrg
If (cell.Value = "") Then
cell.EntireRow.Hidden = True
Else
cell.EntireRow.Hidden = False
End If
Next cell
Next i
Next j
End Sub[/code]