Deleting rows with specific data

[JerBear]

Hello! I have several hundred lines of data on one worksheet, where I'm looking for "IMP" in column A and deleting the row with "IMP" in it. The word "IMP" can appear on any row within the column. I have two issues that I can't figure out. The first is, how do I select column A without setting a range of rows? The second is, when this code runs I receive an error "Type mismatch" after the last "IMP" line is deleted.

Thanks in advance!

Book2.xlsm

Please Login or Register  to view this content.

[Mumps1]

Try this code. It will automatically adjust for the number of cells in A that have data.

Please Login or Register  to view this content.

[JerBear]

Thanks Mumps1! But I get a "Type Mismatch" error for "If Cells(x,"A") = "IMP" Then"

[JOHN H. DAVIS]

Another option:

Please Login or Register  to view this content.

[Mumps1]

Sorry, JerBear. I noticed the sam thing and corrected the code. Try:

Please Login or Register  to view this content.

[JerBear]

Mumps1 - with the updated code, any lines below "IMP" get deleted as well.

John - I get an error: "Object doesn't support this property or method" for line "Activesheet.UsedRange.AutoFilterMode = False."

[JOHN H. DAVIS]

Mumps1 - with the updated code, any lines below "IMP" get deleted as well.

John - I get an error: "Object doesn't support this property or method" for line "Activesheet.UsedRange.AutoFilterMode = False."

Oops

Please Login or Register  to view this content.

[JerBear]

JHD - interesting concept - I never thought to use the Filter! Thank you - your code worked just fine. I appreciate your time to help me!

[JerBear]

Mumps1 - Thank you for your time - I can use the code you provided in another part of my workbook!

[Mumps1]

I'm glad everything worked out.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.