-
VBA Code to remove Data embedded in the "Pick From Drop Down List"
I have written a code to delete rows if they are blank. See the code below. The code works when the cell is blank. However, the cells appear to be blank. But, in fact there is an embedded set of values that you can see in the "Pick From the Drop Down List" (right click in the cell). This is what it looks like, as an example when I right click on a cell ....
Blank
4701
4702
4703
etc..
But if it appears blank when I look at the cell, how do I get rid of this list, because my code only deletes a row if the row is empty. And in this case it is blank but yet VBA thinks there is a value because of this Drop Down List which includes these values. Make sense?
Any idea how I can get this to be no value when it looks like it is blank?
Code:
Sub Delete_Blank_Rows2()
On Error Resume Next
Range("A1:A100000").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules