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?