fluffyvampirekitten
Board Regular
- Joined
- Jul 1, 2015
- Messages
- 72
i want to search for all the blank cells and delete those ?
any idea ?
vba..
thanks in advance
any idea ?
vba..
thanks in advance
Not sure if you prefer vba or not but here is the non-vba method. Select the rows/columns where you want to search for blanks. Press F5, click Special and select blanks. This will automatically select all blanks in the selected area. These can then be deleted in the HOME tab ->Delete.
Alex
Blank cells where ??
I have a list of data like around thousands , most of the rows are blank and its in between two data.
Idea: I want to delete all the blank rows and do a filter ( A to Z)
AND
Do you only want to delete the cell or the row ?? I want to delete the row.
By deleting blank cells within a range of data, any adjacent data will be incorrect once the blank cell is deleted ??
Sub MM1()
With Columns("A")
.AutoFilter field:=1, Criteria1:=""
.Resize(Rows.Count - 1).Offset(1).EntireRow.Delete
.AutoFilter
End With
End Sub
If the blanks are in Col "A", try
Code:Sub MM1() With Columns("A") .AutoFilter field:=1, Criteria1:="" .Resize(Rows.Count - 1).Offset(1).EntireRow.Delete .AutoFilter End With End Sub