Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching a column
Help please !!
Last week I posted this as follows; ""I would like to search a column of data for 'part characters' : eg user enters "lock" and macro searches column A and comes up with "block" in cell A6 and "locket" in cell A9. I am thinking this might incorporate the use of the LEN command, but without writing an immense amount of code I am sure there must be a more simpler and more efficient method."" And I received the following reply; "You will need to set SearchValue to the user input. With Range("A:A") Set rng = .Find(SearchValue, LookIn:=xlValues, LookAt:=xlPart)"" Well I have been really struggling ! Can anyone please send me a brief example of how I approach the code Ever so grateful Robert Pollock. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching only one column in Excel | Excel Discussion (Misc queries) | |||
Searching up a column | Excel Discussion (Misc queries) | |||
Searching One Column Only | Excel Discussion (Misc queries) | |||
Searching a Column | Excel Programming | |||
Searching In a Column | Excel Programming |