Hi

Maybe I haven't explained myself properly. I'm basically trying to find
the number of spaces contained in a word:

eg. (" Jean") I want to be able to say that if the value of the
activecell has 3 spaces at the begining of it then....else....

I think it would be along the lines of this piece of code
(ActiveCell.FormulaR1C1 = "=LEFT(R[2]C, FIND(""2"",R[2]C)-1)") except
that I dont want the formula to be dumped in the activecell.

if ActiveCell.value has 3 spaces in front of it then
...
else

if ActiveCell.value = 5 then
....

else

if ActiveCell.value = 7 then
....
end if
etc...


Hope this explains it a bit more. Thanks for all your help in advance

Kind Regards


--
poppy
------------------------------------------------------------------------
poppy's Profile: http://www.excelforum.com/member.php...o&userid=11453
View this thread: http://www.excelforum.com/showthread...hreadid=558331