i have the following code (that works!) to delete rows if the cell in column B in that row is blank. I need this changed to only delete cells in column A, B and C but not the entire row.
so if the cell is blank in column B i only want it to delete and shift up the first three columns of that row instead of the whole row.
heres the code
thanks for any help![]()
Sub DeleteRowsInItem() Dim Lastrow As Integer Lastrow = Range("B" & Rows.Count).End(xlUp).Row Range("B4:B" & Lastrow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub
JD
Bookmarks