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