Macro to delete rows that contain specific words

N

Neil

Hi,

The macro i am trying to build needs to open a deisgnated file and
each row in column A that has the given word to delete the row and
move everything up.

i.e.

Mark
apple
apple
Steve
John
apple

So in the above example the data is in column A so the macro will scan
through and delete the rows that display apple.

Any help would be greatly appreciated.

Thanks
Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top