Since it is now counting backwards, would reversing the order of my search strings have any impact??
No!
Try this one and will be away until this afternoon.
Sub DelColumnNotInList()
Dim i&, LC&, myrng1
Application.ScreenUpdating = False
LC = Cells.Find("*", , , , xlByColumns, xlPrevious).Column
For i = LC To 1 Step -1
If InStr("Text1 Text2 text3 Text4 Text5 Text6 Text7 Text8 Text9 Text10", Cells(1, i).Text) = 0 Then
If myrng1 Is Nothing Then
Set myrng1 = Cells("A", i)
Else
Set myrng1 = Union(myrng1, Cells("A", i))
End If
End If
Next i
If Not myrng1 Is Nothing Then
myrng1.EntireColumn.Delete
End If
Application.ScreenUpdating = True
End Sub
Bookmarks