Just an FYI..

I actually solved this little problem - The series of
dots actually had an autocorrect match which meant it was
automatically changing.

thx stuart


-----Original Message-----
On Fri, 1 Aug 2003 03:39:40 -0700, Stuart wrote:

I used the find method inside Excel 2000 VBA to return
data from a legacy system. When I looked at the string
in
excel that my find was trying to match, I noticed that
a
series of dots were being shown in Excel as a bold
vertical line, meaning the find method wouldnt find
the
string.

Any ideas ?

thx stuart

Could you use the InStr-function? (See VBA-help for
details).

InStr(String_to_check,String_to_find,vbTextCompar e)

SL
.