If you're using xl2002 (or higher):

MsgBox UCase(MonthName(3, abbreviate:=True))



douvid wrote:

Hi ,

lets say I have set X = 1 and I want this to become x=JAN , y=2 to y=FEB, .... I know I can do this through the textocolumn but my problem is that these are variables in my macro and not cells in the worksheet.

Is there a way I could achieve this ??
Thanks for your help.

--

Dave Peterson