| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help with finding a concatenated string
on one sheet, i want to concatenate 3 cells, say c2,d2,e2 (strToFind)and then
search for that string on another sheet in columns b,c and d concatenated. what is the syntax for the find? strToFind = ws.Range("C" & irow) & ws.Range("D" & irow) & ws.Range("E" & irow) Set rngfound = ws2.Range("B2:D" & nextrow).Find(What:=strToFind, _ LookIn:=xlValues, lookat:=xlWhole) -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font formatting in a concatenated string | Excel Discussion (Misc queries) | |||
| Splitting a concatenated string into separate rows... | Excel Worksheet Functions | |||
| How do I break up a concatenated text string ? | Excel Discussion (Misc queries) | |||
| Bold a portion of concatenated string | Excel Discussion (Misc queries) | |||
| specify range name in formula with concatenated string | Excel Worksheet Functions | |||
Threaded Mode
