Sub FindDoubleBlank() While ActiveCell.Row > 1 If ActiveCell.Value = "" And ActiveCell.Offset(-1, 0).Value = "" Then ActiveCell.EntireRow.Delete End If ActiveCell.Offset(-1, 0).Activate WendEnd Sub
Post a Comment
No comments:
Post a Comment