Hello,

I have a confusing problem with some VBA I have written for MS Excel.

I am using the find function as shown below

Cells.Find(What:="a-", After:=ActiveCell, LookIn:=xlValues, LookAt
_
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False).Activate

This works perfectly with

What:="a"

but not when i add the "-".

I have had this working with "a-" on another computer also which makes
it even more confusing.

Might I be missing a VBA reference library, there are so many I dont
know how to tell which I might be missing.

OS: Windows NT
Excel: 2000

thanks in advance...

A