Deleting rows based on conditions being met

Hi there!

I have a worksheet called "DO2" with 4 columns and I'm trying to write two different macros for it.

1) Delete all rows if the first letter of a cell in column D is "d". The Range is the entire column D

The second, separate macro I'm trying to write is

2) Delete row 2 if DO3!B2=DO3!B3 AND DO3!D2=DO3!D3, do this for all rows in the entire length of the column. For example for row 100 you would delete row 100 if DO3!B100=DO3!B101 AND DO3!D100=DO3!D101


Thanks so much!
Shar

Regards your first query - Colin Legg has provided a detailed tutorial on efficient methods for deleting rows - see: http://www.xtremevbtalk.com/showthread.php?t=300757

Regards your second query, a basic example:

Please Login or Register  to view this content.

the above makes certain assumptions re: contiguous areas and used columns but should work based on the info. provided - if not post back.