Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am using this code to delete the row if the cell in column A is blank. Dim i, j As Integer Set starta = ActiveSheet.Range("a2") LR = ActiveSheet.Range("a" & Rows.Count).End(xlUp).Offset(1, 0).Row For i = LR To 0 Step -1 If starta.Offset(i, 0).Value = 0 Then starta.Offset(i, 0).EntireRow.Delete Next i I would then like to delete a row if the cells in columns B, C, D, and E are all blank even if the cell in column A is not blank Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting rows with blank cells after a specified column? | Excel Discussion (Misc queries) | |||
Deleting blank cells w/o impacting other rows/columns | Excel Programming | |||
Deleting blank (Cells/Rows) in Excel-VBA | Excel Programming | |||
Deleting rows with blank cells | Excel Programming | |||
Deleting rows with blank cells | Excel Worksheet Functions |