I have a delete empty row function. This works fine ! little modification is necessary. Now he delete a line when the first cell is empty. He should verify the values of a row or at least a range. I tried rows(i4Row), not working.
For i4Row = lLR To 2 Step -1 If sh.Cells(i4Row, "A").value = vbNullString Then sh.rows(i4Row).EntireRow.Delete End If Next i4Row
Bookmarks