Missing Right and Format function in Excel 97
Tom
Thanks a lot
I thought the reason is because excel97 can't use Right and Format Function..
But actualy it is missing the WordDLL as reference.
"Tom Ogilvy" wrote:
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
|