View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnE JohnE is offline
external usenet poster
 
Posts: 14
Default date/year method

I am wanting the current month and year to show in range
(A6) thru the use of code and a button. But, I am having
difficulty using the month(date) as it returns a number
for the month. I haven't tried to add the year until I
get the month figured out.
How do I go about getting the Month - Year into a cell
from code?
Thanks for any assistance.
*** John