VBA to hide row if cell is blank given a pre selected range of rows

[joecom88]

I am looking to hide rows if column B is blank using a pre-selected range of rows.

I have several data blocks on a sheet that feed charts and as I copy/paste data into it, I select the range of rows then I plan on running this module using the pre-selected range (so I don't have to make a dozen specific hide modules) to hide empty rows.

I'm using RowDdx and I can't quite get the variables to work with it.

Greatly appreciate any help.

 

[CalcSux78]

Have you tried a worksheet_Change event on the target sheet to trigger your macro?

Here's a rough example:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range, Row As Integer
Set Rng = Intersect(Target, Range("A:A"))
If Not Rng Is Nothing Then  [COLOR=#008000] 'two ranges intersect[/COLOR]
    Row = Right(Rng.Address, Len(Rng.Address) - 3)
   [COLOR=#008000] 'test to see if data is blank[/COLOR]
    If Range("A" & Row).Value = "" Then
        Rows(Row).Hidden = True
    Else
        Rows(Row).Hidden = False
    End If
End If
End Sub