Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting an entire row if the cell in col A is empty
would some one please help me w/ the coding for a loop for deleting an entire
row if the cell in column A is empty. I've tried several FOR EACH loops w/ little success. Thanks Zb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting an entire row if the cell in col A is empty
Sub delete_rows()
Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.UsedRange.Rows.Count For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "" Then Rows(RowNdx).Delete End If Next RowNdx End Sub Gord Dibben MS Excel MVP On Wed, 7 Mar 2007 16:50:08 -0800, Zb Kornecki <zDOTkorneckiATcomcastDOTnet wrote: would some one please help me w/ the coding for a loop for deleting an entire row if the cell in column A is empty. I've tried several FOR EACH loops w/ little success. Thanks Zb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to SUM entire column, but only when adjacent cell is not empty | Excel Worksheet Functions | |||
Deleting entire row if cell contains "value" - how to review everytime? | Excel Worksheet Functions | |||
Making a cell blank or empty without deleting it | New Users to Excel | |||
deleting entire rows with the same cell value in the first column | Excel Discussion (Misc queries) | |||
empty a entire row | Excel Programming |