View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Francesco Sblendorio Francesco Sblendorio is offline
external usenet poster
 
Posts: 12
Default Removing Blank Rows?

I'd try this:

---------------------------------------
Lastrow = Activesheet.UsedRange.Rows - 1 + _
ActiveSheet.UsedRange.Rows.Count
Application.ScreenUpdating = False
r = Lastrow
Do While r = 1
If Application.CountA(Rows(r)) = 0 Then
Rows(r).delete
Else
r = r - 1
Loop