Automatic Year Change in VBA

Hi

Please Login or Register  to view this content.

With the above code I have twelve of them one for each month April 2013 to March 2014. Can I get the year to change automatically for 2014 to 2015 or do I have to edit each year manually and resave. Or is there a better way.

Many thanks

Chris

I can't write the code for you, but in a Excel-formula,

=day(celladress) will gives you the day

=month(celladress) will gives you the month

=year(celladress) will gives you the year

Hi Oeldere

Complete novice at this VBA but at least you have given me something else to pull my hair out over. Given your star a good kicking sorrry clicking.