View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_3_] Otto Moehrbach[_3_] is offline
external usenet poster
 
Posts: 31
Default Setting up a Month Array

Excel 2002, Win XP
I have a need to get a Text month from a number month. IOW, if I have a 3,
I want to get "Mar" without the quotes.
I think I need to set up an array something like:
Months(Array("Jan","Feb","Mar" etc))
Then Months(3) would get me "Mar".
Obviously I don't know the code to do this. If someone could help me with
this, it would be much appreciated.

If there is an easier way to get "Mar" from 3 that would help too. However,
I would still like to have help with setting up an array like the above
because I need the education. Arrays are new to me as you can tell.
Thanks for the help. Otto