| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select rows and delete based on criteria
hi sorry for being a pain...
I have a worksheet with data from column A to E and from rows 1 to (lets say) 5000. I want a macro that serches for rows that have "2" in column C and are NOT BLANK, then select all thses rows from column A to IV (not just A to E) and then delete them (shiftng all other rows up but i think this happens automatically. How can I do this. Also in the resulting table I want to select all remaianing rows (again from A to IV). thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows based on multiple criteria | Excel Discussion (Misc queries) | |||
| How can I delete rows programmatically based on certain criteria? | New Users to Excel | |||
| Delete rows based on criteria | Excel Discussion (Misc queries) | |||
| Delete rows based on certain criteria | Excel Discussion (Misc queries) | |||
| Select rows based on criteria | Excel Worksheet Functions | |||
Threaded Mode
