Needed some help finding the exact text in a cell instead of finding a cell that contains even part of the word. Currently the code I'm using finds a cell that contains part of the text and uses it, but what I need is to find the Exact text in a column instead. Here is the code I use:
Set Obj = wsActiveSheet.Cells.Find("Area") If Obj Is Nothing Then MsgBox "Target column is not found" Else AreaY = wsActiveSheet.Cells.Find("Area").Row AreaX = wsActiveSheet.Cells.Find("Area").Column End If Columns(AreaX).Select Selection.Copy ActiveSheet.Cells(1, 101).Select ActiveSheet.Paste
Thanks in advance!