Hide Blank Rows based on 2 columns

I have a bit of code that I used a while back but need to tweak it. The code currently works well and hides the blank rows at the bottom of a single column range. This is what I need now:
-I want the code to look at the data in BOTH columns C and D. Then hide the rows that are below the last line whether its in column C or D. I have tried just changing the Range in the code but that doesn't seem to work. Any help would be great.
Thanks
Rob

Dim rng As Range
  Range("C5:C30").EntireRow.Hidden = False
  For Each ce In Range("C5:C30")
    If IsEmpty(ce) Then
      If rng Is Nothing Then
        Set rng = ce
      Else
        Set rng = Union(rng, ce)
      End If
    End If
  Next ce
  rng.EntireRow.Hidden = True

Hi

Try

Dim rng As Range
  Range("C5:C30").EntireRow.Hidden = False
  For Each ce In Range("C5:C30")
    If IsEmpty(ce) And IsEmpty(ce.Offset(0, 1)) Then
      If rng Is Nothing Then
        Set rng = ce
      Else
        Set rng = Union(rng, ce)
      End If
    End If
  Next ce
  rng.EntireRow.Hidden = True

rylo

Thanks Rylo - you came to rescue again.

Your right my mistake, her is the link to the other forum. Won't happen again.

http://www.mrexcel.com/forum/showthr...=1#post1454177