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.