View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
p. panter p. panter is offline
external usenet poster
 
Posts: 10
Default delete just empty rows

how can I delete just empty rows of a sheet

with the following code I can just delete empty cells and after that the
rows are not the same as before (have different values).

Sub emptyCellsDelete()
sheet1.Cells.Range("A6:M155").SpecialCells _
(xlCellTypeBlanks).Delete shift:=xlUp

End Sub