anthony20069
10-14-2008, 02:12 PM
Hi guys,
Need your excellent assistance again please : pray2:: pray2:
Ok so here is the dellema (think I spelt that wrong)
I have got a sheet and in now row G it has many rows of dates. Now each month I have to manualy go into this spreadsheet and update these dates )which are not all the same and also vary in months some of them) to show the new dates for the new month e.g.
From To
14/10/2008 --> 14/11/2008
2/09/2008 --> 2/10/2008
Now, i was wondering if some how there could be a way to update all these dates to show the next months date on the same day in VBA, i did try but all i could figure out was to do this:
range.("G2").value = range.("G2").value + 30
Which obv has many draw backs as i would need to do that for all 100 + dates as well as it doesnt give accurate dates.
Any help would be amazing
:bow:
Thanks
Anthony
Need your excellent assistance again please : pray2:: pray2:
Ok so here is the dellema (think I spelt that wrong)
I have got a sheet and in now row G it has many rows of dates. Now each month I have to manualy go into this spreadsheet and update these dates )which are not all the same and also vary in months some of them) to show the new dates for the new month e.g.
From To
14/10/2008 --> 14/11/2008
2/09/2008 --> 2/10/2008
Now, i was wondering if some how there could be a way to update all these dates to show the next months date on the same day in VBA, i did try but all i could figure out was to do this:
range.("G2").value = range.("G2").value + 30
Which obv has many draw backs as i would need to do that for all 100 + dates as well as it doesnt give accurate dates.
Any help would be amazing
:bow:
Thanks
Anthony