October 24, 2021
October 5, 2010
You haven't supplied a workbook with sample data so I'm guessing at what you are working with.
You could try this
If Not Range("A:A").Find("Total", Lookat:=xlWhole) Is Nothing Then
But it's better not to select entire columns. Try creating a table or named range, or just working with the range containing data if you know it e.g. A1:A10.