VBA Delete Entire Row if Contains Certain Text

  • On sheet1, In column D, If any of the cells contains "Record Only" I need it to delete the entire row along with next 15 decending rows to be delete.

    Thanks.

  • Try this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Hi,


    Thanks its working, one issue if data last line and Record Only in-between blank line then this codes skips. I am thinking if suppose in future this happens then?

  • The fastest way ts to utilise AutoFilter


  • CurrentRegion stops at an empty row, so the "Record Only" would not be included. Try

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!