Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Find/Search Criterias
Hi all,
I was wondering if there is anyway i simplify the following code to do multiple search criterias. On Error Resume Next Cells.Find(What:="valdate", After:=ActiveCell, _ LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Cells.Find(What:="invaldate", After:=ActiveCell, _ LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate On Error Goto 0 Thanks in advance Ray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Find/Search Criterias
'*valdate' (w/o the quotes) will work in this specific instance.
However, AFAIK, there is no generic 'or' or 'and' capability within the Find method. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi all, I was wondering if there is anyway i simplify the following code to do multiple search criterias. On Error Resume Next Cells.Find(What:="valdate", After:=ActiveCell, _ LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Cells.Find(What:="invaldate", After:=ActiveCell, _ LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate On Error Goto 0 Thanks in advance Ray |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Find/Search Criterias
Hi Tushar
Thank you for your tip, i guess i will have to find a better way, coz i am searching for multiple different words and cannot just use a wildcard. Have a good day. Rgds Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find MAX of column from using 2 criterias | Excel Discussion (Misc queries) | |||
Search criterias? | Excel Discussion (Misc queries) | |||
DCOUNT WITH MULTIPLE CRITERIAS | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
multiple search criteria to find and copy from sheet1 and paste into sheet2 | Excel Programming |