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

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