Delete Entire Row

[computerman29651]

I need a formula that will look for a certain word, and if that word is found, then delete the row.

For Example:

Column F
Read (test)
Write
Talk (test)
Run
Walk (test)

So, what I need is a formula that if (test) is found, then delete the entire row.

If any additional information is needed, please let me know.

 

[PHV]

Have a look at the Find method and the EntireRow property.
Tip: the macrorecorder is your friend.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

I'm cautious about deleting data -- gooooonnnnn forever!

Take a look at the AutoFilter CONTAINS criteria.

Skip,

_[red][/red]