I'm a VBA newbie. I want to set a macro to delete rows. There are two conditions - 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

C	D	E
1		WBS Level 2 Item
	1.1	WBS Level 3 Item