Yep.
I have tried everything and now i put it out to the experts as I just cant get this to work. I thought it would be simple. here is the code

variables: MO = 10
YR = 2011

I am trying to take MO which is represented as a two digit number and turn it into its full month name and store that in a variable called vMonth.

this just does not work......vMonth = vMonth = Text(DATE(vYear,MO,1),"MMMM")

It works in a spreadsheet where i enter =Text(DATE(vYear,MO,1),"MMMM")
where vYear is a cell containing 2011 and MO is a cell containging 10. In this case it results in "October". But in the VBA module i just cannot get it to stop erroring out with the following message: COMPILE ERROR ...SYNTEX ERROR.

Also this whole line is in red of code is in red.

Can someone help me figure out why the code will not produce vMonth="October"?

Thank you in advance.