| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and return value
Is it possible to use a macro to search a sheet to find several value eg, a/b/c/d/e (which could be anywhere on the sheet) and if any of the are found a message is posted in the active cell stating eg "a apples", "b = bananas" with nothing being posted for those not found? Is this,or anything similar, possible? Any help would be much appreciate ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search value in 2 columns return value in another | Excel Worksheet Functions | |||
| Search a column for a value and return T or F | Excel Discussion (Misc queries) | |||
| search and return adjacent value | Excel Discussion (Misc queries) | |||
| Search and return | Excel Worksheet Functions | |||
| search for and return more than one row in a sheet | Excel Worksheet Functions | |||
![index[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
