Macro to change date list

**Directlinq** · 02-19-2009, 08:32 AM

Hi i have a list of dates from A1 to A31 , say in january 2009. from the 1st to the 31st, Im trying to get a macro that when i run it it removes all these dates and replaces them with feburarys dates 1st to the 28th. run the macro again and it changes the dates to march etc etc.

How is this possible please?

So many thanks

**DonkeyOte** · 02-19-2009, 08:39 AM

One way:

Please Login or Register  to view this content.

**Directlinq** · 02-20-2009, 03:13 AM

I feel really stupid asking this but i cant for the life of me figure out how to make this work when my date list is between A5 and A35. It works perfectly if my first date is in A1.

Please Login or Register  to view this content.

Many Thanks

**DonkeyOte** · 02-20-2009, 03:20 AM

Please encase VBA in CODE Tags (use the # icon) -- please edit your last post and update.

To answer your question and to make the system more flexible let's alter the approach:

Please Login or Register  to view this content.

If you need to alter the range going forward you merely need to alter the A5:A35 statement (mindful of course that the above assumes the date range to always be vertical).