A Macro to hide/unhide rows

[fabs]

I'm not really up on VBa ad I'm looking for a way to hide/unhide rows in a spreadsheet depending on whether a certain cell is blank.

eg, cells A11:A34 have a formula which either picks up a name or is blank, depending on the cntents of another cell. If the result of the formula is blank, I want to hide that row (and vice versa). Is this possible?

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Calculate()
Dim i As Long
For i = 11 To 34
    Rows(i).Hidden = Range("A" & i).Value = ""
Next i
End Sub

 

[fabs]

Brilliant, works perfectly.

Thanks