Hi all, fairly new to VBA and programming
Need some help with trying to build something where if a cell is blank then a range of cells in that row get deleted and shifted up. I can no longer use this code because I have information on the far right that could get deleted:
So now I have to go in a different direction but for some reason it deleted my entire table (A2:O41) and seems that my if statement is not written right. This is to clean up a table of information starting with 41 rows and spans out to column O. The top line is the header.![]()
Columns("K:K").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
What am I missing? Thanks in advance!![]()
For i = 41 To 2 Step -1 If Cells("K" & i) = "" Then Range("A" & i, "O" & i).Delete End If Next i
Bookmarks