| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text in column
Column E typically contains the following text entries.
As part of a module I need to find the row of the cell in which a specified string appears. iRowNum is the row sought. sItem is the string to search for. NB. There are several blanks cells between entries in the column. iRowNum = ...sItem...? D01-001 D01-002 D01-003 D01-004 .. .. .. D02-003 D02-004 D02-005 .... Many thanks, Francis Hookham |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the first cell to contain text in a column | Excel Discussion (Misc queries) | |||
| Find a text from a column in a text string within another column? | New Users to Excel | |||
| FIND LAST COPY OF A TEXT IN A COLUMN | Excel Discussion (Misc queries) | |||
| Find text in Column or Range Name | Excel Programming | |||
| Find text in Column to sum | Excel Programming | |||
Threaded Mode
