Dear Friends,
i have been trying to find a cell content in a column.
below is the code that i am using
Selection.Find(What:="CAE-Z000123", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
my problem is the code above serches the cell even if half the contents are found in any of the cell in the column. what i need is exact find of the cell value in a column.
Hope i have clarified to the larger extent.
please friends if some one could help me out.
Bookmarks