Deleting Entire Row Based on Criteria in single cell

Preface: I am learning VBA as I go over the last three weeks, so please explain any solutions like i'm a complete idot. Thank you so much in advance for any help.


Prefered:

I want to Delete an entire row based on a criteria in column D (Criteria:= "REMOVAL BLANKET")

Or

Acceptable:

I would Like to Delete all Visible Rows from a Flitered Selection of Colum D.

My Current code is:
See ISSUE 1: I need to get the entire row selected to delete. cant seem to scipt it right

Please Login or Register  to view this content.

Hi,

Welcome to the forum.

Paste the following code to a module. Test on copy file.
This will start at the bottom of column D and then go to row 2 of column D.
When it see your criteria it should remove that row and then continue to the next row.

Please Login or Register  to view this content.

Have a look at the "Using The Range Object's Autofilter Method" example on the link below; it should give you a pretty good idea how to go about it.

http://www.xtremevbtalk.com/showpost...70&postcount=4

Note that it doesn't use the Selection object at all.