Trouble with Find in VBA

Try:

Please Login or Register  to view this content.

in place of:

Please Login or Register  to view this content.

I'm still getting the run time error on the first line of code...



I've attached a workbook.

Hello Panda2000,

What are you looking for in column "A"?
Once the value is found, do you really want to delete that entire row?

Hi Panda2000,

This works but I'm not sure that it's what you wanted:

Please Login or Register  to view this content.

Would it work to use boolean operators such as Or in the Let What = "API" portion of the code? There are several items for which I am searching; "api", "irrigation", and "gels". Ideally I would like to use the Instr function as there is sometimes variability in the text strings to some degree. Once these rows are found I'm sure that they are to be deleted.

I don't think that would work. But here's an interactive routine that lets you enter your search values individually and it's set to quit on a null entry:

Please Login or Register  to view this content.

Would you know how to convert that "what" value into an Instr function? So if "irrigation" was contained in any part of a text string that would be found as a match and then the row deleted? Also, how would I modify the code to delete the entire row and not just the cell?

I'm using this more as a learning experience, hence the many questions.

Hello Panda2000,

Change the argument LookAt in the Find from xlWhole to xlPart.

Hi Panda2000,

If you want to use InStr then we'd need to reprogram the routine without the Finder.

But to delete the whole row:

Please Login or Register  to view this content.

You're welcome!