Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows
-----Original Message----- I need my macro to delete rows that start with specfic data, not clear the row but delete. If row begins with text "bo501" delete. T.I.A. Dayton . Try this as an example. For your case the If statement should check the value to see if it is equal to "bo501". The problem with this macro is that it is very slow on large data files. This is because the sheet is updated after every delete. I've been looking for a method to select all the rows found and then do a delete of all of them at the same time, however, I haven't found any help in that department. Sub test() For Each rw In Worksheets("Sheet1").Rows If IsEmpty(rw.Cells(1, 1).Value) Then rw.Delete Next rw End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |