sunilmulay
10-06-2008, 03:23 AM
I'm a VBA newbie.
I want to set a macro to delete rows. There are two conditions however - see example below. If the user selects the last line (condition = if there is data in column D in the row containing the active cell), then the macro should delete the row as well as the 5 following rows. If the user selects the first line (condition=if there is no data in column D), then only that row should be deleted.
any ideas?
thanks! Sunil
CDE1WBS Level 2 Item 1.1WBS Level 3 Item
I want to set a macro to delete rows. There are two conditions however - see example below. If the user selects the last line (condition = if there is data in column D in the row containing the active cell), then the macro should delete the row as well as the 5 following rows. If the user selects the first line (condition=if there is no data in column D), then only that row should be deleted.
any ideas?
thanks! Sunil
CDE1WBS Level 2 Item 1.1WBS Level 3 Item