Delete Row Based On Cell Criteria

[NewExcelUser]

Good Day,

I would like to delete a row based on cell criteria

I would like the function to equal this:

If cell A1 = 3, Then Delete the corresponding row with the number in the first column.

For instance:

Cell a1 contains a number which output is random by that of a command button.

I also have a column that is numbered 1 through 74. If the number in cell a1 matches that of the row, then that row is to be deleted. I have been at this for a while and still cannot nail this. Any help would be greatly appreciated. Thanks.

[jetted]

hi

Always a good idea to provide a sample of your work. If you do provide a sample I will have a look at it. It sound what you are trying feasable

[NewExcelUser]

Hello,

I have attached a sample below.

Thank you for your time.

[NewExcelUser]

I have started working with this code... although I do get a Compile Error: Variable Not Defined when running.

Please Login or Register  to view this content.

Still at it...

[NewExcelUser]

I don't get it, I just don't get it. This code works to delete a row based on criteria input from a userform:

Please Login or Register  to view this content.

I thought my code search would produce something similar, but it doesn't. I don't know how to modify the code above to fit my needs, if that is even at all possible.

I tried modifying the code below from a webpage without success:

Please Login or Register  to view this content.

Where "Randomizer!d3" is the criteria I wish to search within another sheet and have the row deleted if it finds it.

[mikerickson]

I hope this helps.

Please Login or Register  to view this content.

[NewExcelUser]

OMG You're a Genius!

My hours of frustration has come to a close with success! I was contemplating throwing in the towel on this one for the night when I was hoping to have this ready for tomorrow and thanks to you I will!!

GREATLY Appreciated.

Thanks Mike.

[mikerickson]

You're welcome.

[rengel1]

Hi,

I was wondering if someone could help out with a similar issue I've ran into. I'm trying to delete all rows within a selected column which have "USD" as the criteria.

For example, column "I" contains currencies, how can I remove USD rows in the spreadsheet?