macro for month named ranges

[freshfruit]

Hello. If I have a date for each day for the entire year, how can I create a macro that applies named ranges to each month. Jan, Feb, Mar, etc. I know it would be probably be easier to just manually select, but I'm curious. Thanks. Please explain the code in as much detail as possible. Obrigado.

[p24leclerc]

You can try the following macro

Please Login or Register  to view this content.

I manually set the year to 2014 in the code. If you need another year, you may change it in the code or create a variable or ask the user to enter it in a cell.