Excel Macro Code to Delete Entire Row if based on certain word

[constantinet]

I am new to creating excel macro so sorry if it is simple question

I am looking for excel macro that will delete the entire row if the following item, VI/9766, is found in column G.

Thank you in advance for any help.

 

[Fluff]

How about

Sub constantinet()
   With ActiveSheet
      .Range("A1:G1").AutoFilter 7, "VI/9766"
      .AutoFilter.Range.Offset(1).EntireRow.Delete
      .AutoFilterMode = False
   End With
End Sub

 

[JoeMo]

I am new to creating excel macro so sorry if it is simple question

I am looking for excel macro that will delete the entire row if the following item, VI/9766, is found in column G.

Thank you in advance for any help.

Will that be the entire content of col G cells or part of a longer string?