Delete rows that match criteria

[PhilSM]

I would like a macro that scrolls through each row and deletes it if it contains the word "Account" in column B.

Thanks for any help

[DonkeyOte]

There a variety of ways to do this ... some will loop but I quite like to use the following method:

Please Login or Register  to view this content.

[PhilSM]

Quite like this, is it possible to make the search and column variable ?

[DonkeyOte]

To be honest if you wanted it to be dynamic etc you would be best served reverting to the traditional loop & find method ... such that you can easily do partial matches etc...

A slightly more dynamic version of the prior method would be along the lines of:

Please Login or Register  to view this content.

But to reiterate - making the above more flexible is pretty worthless given standard Find method offers greater inherent flexibility for less effort ;-)

As I say for the odd check here & there I prefer the .SpecialCells method as I'm not a fan of looping... anything more complex... Find & Loop... you should find lots of examples here of the Find & Delete approach.

[Shijesh Kumar]

try this if this is of any help


Below code will ask you what you want to delete and in which column u want to search

Eg. Input what u want to delete as "Account"
and for Column enter 1 , 2 , 3 etc.

Please Login or Register  to view this content.

[PhilSM]

Thanks very much, these both work a treat.