View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nc
 
Posts: n/a
Default Help write Macro

Roger

Thanks for your reply.



"Roger Govier" wrote:

Hi

If it is only for display purposes, you don't need a macro
In B2 enter =A1 then format the cell as follows
FormatCellsNumberCustom mmmm

Regards

Roger Govier


nc wrote:
Date Month


I have two columns as above Date and Month. I would like to use a macro to
write the function =MthName(MONTH(A129)) in the month column in the same row
when I populate the date field.