Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a function that deletes all rows with no value in a certain column?
Hey all, I use Excel 2007. Can it be set up to delete all rows in an excel file when there is no value in a certain column? For instance, every row with no value in column H would automatically be deleted?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
a function that deletes all rows with no value in a certain column?
Hi,
Am Thu, 6 Jun 2013 20:44:41 +0100 schrieb dunndealpr: Hey all, I use Excel 2007. Can it be set up to delete all rows in an excel file when there is no value in a certain column? For instance, every row with no value in column H would automatically be deleted? filter column H for empty cells and delete the visible rows. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
a function that deletes all rows with no value in a certain column?
Hi,
Am Thu, 6 Jun 2013 21:55:30 +0200 schrieb Claus Busch: filter column H for empty cells and delete the visible rows. if you want to do it automatically, then try VBA: Sub DeleteRows() Dim LRow As Long LRow = Cells(Rows.Count, "H").End(xlUp).Row Range("A1:H" & LRow).AutoFilter Field:=8, Criteria1:="=" Range("A2:H" & LRow).EntireRow.Delete ActiveSheet.AutoFilterMode = False End Sub Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidden rows reappearinmg when macro deletes rows | Excel Programming | |||
Macro that Deletes All rows except first row | Excel Programming | |||
Macro that deletes certain rows only | Excel Programming | |||
Why xl deletes 250+ rows using worksheet_change | Excel Programming | |||
Macro that deletes certain rows and not others | Excel Programming |