If you are looking for more than one instance have a look in the vba help
index for FINDNEXT.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Joek" wrote in message
...
I am trying to create macro that will insert a formula in a cell depending
on
part of the contents of another cell.

E.G.
If cell C2 contains the text " v " (lower case v with spaces each side)
then
input a formula in C4

I need a macro because I nned to check a list of entries for three
different
part text entries.

I can do the loop and IF etc its just the 'If the cell contains.......