Find All 2

[FJAY]

Good Morning - I want to do a find All on a value in excel and write the result(s) to a worksheet. Is this possible.....Thanks.

 

[PHV]

Have you tried to play with the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[SkipVought]

FJAY,

There are lots of ways to do this.

Insert a new sheet for the results.

One way that I particularly like is using MS Query via Data/Get External Data -- Excel Files -- Your Workbook, The Sheet with the DATA of interest, -- [Next],[Next],[Next],[Finish] WITH OPTION Edit QUERY.

In the query grid, add a criteria to select the data of interest.

Return the query results to Excel.

Now turn on the Macro Recorder and record EDITING the query.

Post back you results and well help you make it interactive.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[FJAY]

When I use the macro recorder for the find all option nothing is recorded. It only records for the find next option.

Cells.Find(What:="REFbyPOSITION", After:=ActiveCell, LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

Cells.FindNext(After:=ActiveCell).Activate