Macro code to delete entire row if cell in column A is equal to a value

[mm671750]

I need an easy code that searches all of column A and deletes the entire row if the cell has the value "-". It needs to find the last row of data using something like LastRow = Range("A" & Rows.Count).End(xlUp).Row

[alansidman]

try this:

Please Login or Register  to view this content.

[Bob Phillips]

Please Login or Register  to view this content.

[Bob Phillips]

try this:

Please Login or Register  to view this content.

If you are going to loop, loop backwards otherwise the row pointer can get thrown.

[alansidman]

Thanks Bob,

I was just trying to type faster than you can bring things up from OneNote.

Per Bob's suggestion, replace this line in my code

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

My oversight. Thanks Bob for pointing that out.