Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete rows
I am working on a macro that will copy an entire row of
data onto another sheet based on a condition in the first column. the only way i know how to do this is to copy the entire source worksheet into a temp worksheet, tag each row as either keep or delete, delete all of the rows that i dont want, and then copy the remainder to destination worksheet. here is what i am trying to use to delete the rows: For rwIndex = 1 To 1000 With ActiveSheet.Cells(rwIndex, 1) If ((.Value) = "X") Then Rows(rwIndex).Delete End If End With Next rwIndex however, this formula does not work. i can get it to hide the rows (hidden = ture) but not delete. any ideas? thanks |
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) |