Delete row based on cell value

[288enzo]

Hello,

I'm not using a table.

I would like to search column A for a specific value. I would like to delete the row where the specific value is found in column A and shift all rows up 1.

Please let me know if more info is needed. In my mind it seems fairly simple, but then again nothing is truly simple.

Thank you,

 

[Fluff]

Worked perfectly, thank you.

You're welcome & thanks for the feedback.

 

[Fluff]

@cmowla you would be better off preventing an error if the matched values is not found, rather than a general error handler that could be triggered by any number of things. Especially when you give no warning that an error occurred.

Also whilst you "bang-on" about the "dangers" of using Range.Find, without specifying all parameters, your code in post#10 does not specify all parameters.

 

[cmowla]

@cmowla you would be better off preventing an error if the matched values is not found, rather than a general error handler that could be triggered by any number of things. Especially when you give no warning that an error occurred.

Is the other type of error that can occur due to merged cells causing an error with row deletion or protected sheet? (I don't see what other error could result from Worksheet.Match except for if a match isn't found is what I'm getting at, and if an error occurs.)

Also whilst you "bang-on" about the "dangers" of using Range.Find, without specifying all parameters, your code in post#10 does not specify all parameters.

You're correct. I made an edit at the end of the post at the last of the 10 minute window saying that I should have at least allow you to pass an argument for search by value or search by formula. (I don't really know if MatchByte is that important.) But again, yeah, you're correct!

 

[Fluff]

Is the other type of error that can occur due to merged cells causing an error with row deletion or protected sheet?

Amongst other things. You would also get an error if there is a table on the sheet that intersects with the row being deleted.

You're correct. I made an edit at the end of the post at the last of the 10 minute window saying that I should have at least allow you to pass an argument for search by value or search by formula.

You also don't specify the find format.