View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
jsb88 jsb88 is offline
external usenet poster
 
Posts: 2
Default Discarding all hidden cells?

got it.. had a better search ;-) This one works perfectly... no fuss!

Sub test()

Dim r As Range


For Each r In Intersect(ActiveSheet.UsedRange, Columns(1))
If r.EntireRow.Hidden = True Then
r.EntireRow.Delete
End If
Next


End Sub