| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the best way to find a value in a sheet in VBA?
Please help with the coding for .Find
Example, within a range A1:A10 I would have various values, apples, cans, abc, toys, etc. When I write Range("A1:A10").find("abc", LookIn:=xlValues) I get a compile error of expected = What am I missing? "Tom Ogilvy" wrote: It is the most general way if you don't want to loop. You can also use the built in lookup, vlookup, match type functions. -- Regards, Tom Ogilvy "serdar" wrote in message ... .Find(x, LookIn:=xlValues) Is this the only way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can find sheet on workbook have so many sheet ? | Excel Worksheet Functions | |||
| find last row in a sheet | Excel Discussion (Misc queries) | |||
| Find data from one sheet in another sheet | Excel Worksheet Functions | |||
| how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming | |||
| Cant find sheet | Excel Programming | |||
Threaded Mode
