I cannot get the Split() method in VBA to work when there is leading
whitespace.

Also if I try to compare a string to the text in a cell, I have to
actually copy the value from the cell and paste it into my VBA code for
it to be equal. Even if I have the exact same string in my VBA code
that I typed in, it will not say they are equal.


--
reddog9069
------------------------------------------------------------------------
reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
View this thread: http://www.excelforum.com/showthread...hreadid=380570