Hi

The following procedure deletes any cells with UAT in the text of that
cell moving down the column. The problem is in that column are
sometimes words like:

valuation etc etc

This gets deleted because it contains UAT. How do I specify that only cells
with the specific UAT string get deleted?

Sub DeleteUAT()

Dim count As Integer

ThisWorkbook.Worksheets("reporting").Select
Do While count < Range("H65536").End(xlUp).Row
If Cells(count, 14).Value = "UAT" Then
Cells(count, 14).Delete
Else
count = count + 1
End If
Loop

count = 1
End Sub