Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching Data
Hi,
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. Can you help please. Thank You Robert Pollock |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching Data
You will need to set SearchValue to the user input.
With Range("A:A") Set rng = .Find(SearchValue, LookIn:=xlValues, LookAt:=xlPart -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching data | Excel Discussion (Misc queries) | |||
Searching for data | Excel Worksheet Functions | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Data searching between sheets | Excel Discussion (Misc queries) | |||
Searching for Data | Setting up and Configuration of Excel |