Lost Sailor
New Member
- Joined
- Apr 17, 2002
- Messages
- 2
Hello,
I have two excel files. One is a data file and the other is destination file. I'm trying to "find" (match) in data file so that I can copy the values over to the destination file.
However, it return matchs of "2" when the actuall value is "12". Somehow it see the "2" in "12" and think it's an exact match.
Please let me know how to reslove seemingly simple error.
Thanks!
some code...
strEntry = Workbooks(strOutputBook).Worksheets("Raw Data").Cells(intRow, intCol)
.
.
Set rngSearch = .Range(.Cells(1, conWellColumn), .Cells(intDataRows, conWellColumn))
Set rngFound = rngSearch.Find(What:=strEntry, MatchCase:=True)
>>>> what is returned is the value of cell 2's value (in data file) when if "find" a match in cell 12 (destination).
I have two excel files. One is a data file and the other is destination file. I'm trying to "find" (match) in data file so that I can copy the values over to the destination file.
However, it return matchs of "2" when the actuall value is "12". Somehow it see the "2" in "12" and think it's an exact match.
Please let me know how to reslove seemingly simple error.
Thanks!
some code...
strEntry = Workbooks(strOutputBook).Worksheets("Raw Data").Cells(intRow, intCol)
.
.
Set rngSearch = .Range(.Cells(1, conWellColumn), .Cells(intDataRows, conWellColumn))
Set rngFound = rngSearch.Find(What:=strEntry, MatchCase:=True)
>>>> what is returned is the value of cell 2's value (in data file) when if "find" a match in cell 12 (destination).