Check name of the Month and copy to specific column

[SirMaceOne]

Hi All, I need help with simply code. What I need is check the column D find the name of the Month and copy to column I. Please check attached file.

[alansidman]

In I2 =MONTH(D2), format Custom "MMM" and copy down.

[SirMaceOne]

Hi alansidman, Can you prepare for me ready code to past straight to button Thank you very much

[bakerman2]

Try this.

Please Login or Register  to view this content.

[SirMaceOne]

Working perfect big thanks for help

[Rick Rothstein]

Try this.

Please Login or Register  to view this content.

Here is another, more compact way to write the line of code I highlighted in red above...

Please Login or Register  to view this content.

For future readers of this thread who might find this interesting, here is a compact way to create a 1-d array of month names (the Mnths variable should be declared as a Variant)...

Please Login or Register  to view this content.

This code line was the basis for the macro I posted above.