basically i am searching cells for a string of text.

Some of the cells have spaces before the string and some of them have
or 3 spaces between seperate words in the cell so it is hard to compar
for equality.

I cannot seem to get the Split() method to work when there is leadin
whitespace.

It seems to work fine otherwise.

Also I cannot get Trim() to work. No idea why.

May be I need to include some more references, but it is confusing m
greatly.

I am using office 2003 if that helps.

Any help would be greatly appreciated

--
reddog906
-----------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...fo&userid=2445
View this thread: http://www.excelforum.com/showthread.php?threadid=38054