There is no "=" after th emsgbox command
eg

MsgBox = "hello world!"
results in the error that you had.

The code should be

MsgBox "hello world"


Patrick Molloy
Microsoft Excel MVP
-------------------
I Feel Great
-----Original Message-----
i tried to a msgbox like i usually do and get a message
wen i test it
saying
"Function call on left hand side must return variant or
object"

Microsoft Help is no help....i dn't understand wat it
means!


---
Message posted from http://www.ExcelForum.com/

.