Script/Macro to delete certain rows

  • Thread starter Thread starter DanFox
  • Start date Start date
D

DanFox

Can anyone suggest a script i can use to search a worksheet, identify
an entry and delete the row?

i.e.

I want to delete rows containing 'NOP'

1 WAP
2 NOP
3 WAP
4 DEB
5 NOP

The script/macro would automatically delete rows 2 and 5.

any ideas?
 
You must log in or register to reply here.

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

Similar Threads

Execl DrWatson Error 80000007 3
Easiest Way to Delete Rows 4
Delete Rows 3
Relacing partial text strings 9
Macro: Unhiding a row daily 1
Macro to Delete the last N rows 9
Delete certain accounts 9
macro to delete rows if cell blank in column 4

Back
Top