Change Date (numbers) to words.

I'm simplifying a monthly report of about 10,000 rows. The date on each sale is listed as ex. 4/8/2010. I would like to transform this to April 2010.
I want to insert a new column next to the DATE column with the name of the months as I showed above.
Here is what I have so far

Please Login or Register  to view this content.

This code just finds the column where DATE is in, selects the entire thing and inserts a new column next to it. Now I want to put the month Names depending on Date in new col. ex. (5/8/2010 = MAY 2010, 6/2/2010= JUNE 2010, 8/2/2010 = AUGUST 2010, etc)

I hope someone can help.
Thanks.

Rather than using VBA could you not just insert a column and use a formula like this?

=TEXT(A1,"MMMM YYYY")

Dom

If you want code:

Please Login or Register  to view this content.

Dom

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save