I want to delete all rows that contain "M" in the below query

[biffothebear]

I want to delete all rows that contain "M" in the below query. The auto filter is filtering rows containing m in column A. how can I delete these rows where ever a m appears in the column?

This is my macro below. I do not know what to put in the middle of the query


Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="m"

Selection.Delete Shift:=xlUp



thanks

[Trebor76]

Hi biffothebear,

Welcome to the forum.

I may have a solution but you'll need to have a moderator change your thread title to help others searching the net with the same or similar problem (something like "Delete All Visible Rows") and wrap your code as your thread currently breaks Rule 1 and 3 (respectively) of the forum.

Regards,

Robert