How I find specific word in selected column using VBA code|VBA & Macros|Excel Forum|My Online Training Hub

Hi Rutuja,

You haven't supplied a workbook with sample data so I'm guessing at what you are working with.

You could try this

Sub FindWord()

If Not Range("A:A").Find("Total", Lookat:=xlWhole) Is Nothing Then

Range("A:A").Find("Total", Lookat:=xlWhole).Select

End If

End Sub

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.

Regards

Phil