| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delet rows based on cel content
Hi,
How can I create a macro that would delete two rows. The first row is the one where the cell value in Column A is "L" and the second row is the row above it. So if A15, A20, A23 has the value (and only value) of "L" then delete it and the row above it, which would be A14, A19, A22. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows based on cell content | Excel Discussion (Misc queries) | |||
| Need to select/report all rows based on content | Excel Programming | |||
| Delete Rows Based On Content | Excel Programming | |||
| Delete Rows Based On Content | Excel Programming | |||
Threaded Mode
