When I try MsgBox Date in VBE Immediate window, or in the code, i get the error message: RunTime Error '-2147483640 (80000008)' Automation Error.
I am using MS Excel for Mac 2011 Version 14.4.8.

But this works fine in Windows.

Use of MonthName function also returns an automation error.

Can anybody help?