Hi,

I have the following code and it seems to work on excel 97. On excel 2000 it
doesn't work, it gets 'stuck' at 'right'. Is there a different form of code
that will work for both?

MyVal = Right(Result1, 3)

Thanks Michael