Is there an excel function that does an EXACT find- not a substring find in cells? For example if I look for the word address in a column-range search, it finds both the cells for vendor_address and address. I only want to find the "address" value. Ideas? Thank you!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
FINDING an EXACT VALUE
- Thread starter kajaeger
- Start date
If you're talking about the ctrl-f Find, you can choose "find entire cells only". dreamboat@nni.com
Brainbench MVP for Microsoft Word
Brainbench MVP for Microsoft Word
- Thread starter
- #3
Actually I am talking about doing a find in a macro- is there a way to make it "find entire cells" in the macro- example:
Set oColumnDef = ThisWorkbook.Worksheets.Item("Column Def"
Set oRange = oColumnDef.Range("A:A".Find(sTableName)
Set oColumnDef = ThisWorkbook.Worksheets.Item("Column Def"
Set oRange = oColumnDef.Range("A:A"
.Find(sTableName)
bryanbayfield
Technical User
Syntax of Find method is:
expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte)
You can specify to search for entire cells only by specifying xlwhole for the LookAt property. SuperBry!
expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte)
You can specify to search for entire cells only by specifying xlwhole for the LookAt property. SuperBry!
- Status
Similar threads
- Locked
- Question
- Locked
- Question