If you are getting an error, go to tools=references and make sure that you
don't have a reference shown as MISSING. If you do, this is the cause of the
error. Correct the reference (remove it if you don't need it).

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote:

Dim sVal as string

sVal = Right("ABC",1)

sVal = Format(123, "0.00")


as examples

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Leung" wrote in message
...
Hi

Anyone how i can use the "right" function and "format" function in Excel97
VBA coding?

thanks

Leung