I'm using:
With Range("F:F")
.Replace " ", ""
.SpecialCells(xlCellTypeBlanks).EntireRow.delete
End With
but it also delete cell in which nothing is written.
I'm using:
With Range("F:F")
.Replace " ", ""
.SpecialCells(xlCellTypeBlanks).EntireRow.delete
End With
but it also delete cell in which nothing is written.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks