| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete multiple rows
Excel 2000
Hi I would like a macro to Find a cell with unique criteria Delete the row with the cell and 3 rows below. Was able to find the cell then delete the row with the cell but having difficulty deleting the 3 rows below. Currently I have: Range(ActiveCell, ActiveCell.End(xldown).select Selection.delete Tried to code to select additional rows with row+3 in various configuration but it gave me an errors. Obviously I do not know enough. Any help would be appreciated. Thank you PJ |
| 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 | |||
| Delete all rows below certain value on multiple worksheets? | Excel Discussion (Misc queries) | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Delete Rows from multiple Sheets. | Excel Programming | |||
| Delete multiple rows | Excel Programming | |||
Threaded Mode
