Help Requested :How The dates can be auto mate in the column using VBA.

[sanmaya]

Hi,

i have a worksheet in column 7 to 10 i have dates , for example as today is 04/17/2013. so column 7 have heading 04/07/2013 , similarly column 8 have heading 05/17/2013 like that column 10.

i need to automate this column from 7 to 10 that in the next month that is in month of may the date should be 05/17/2013 and column 8 should be 06/17/2013.

please helpo me with this code.

Thanks in advance.

 

[njimack]

Excel Workbook
	G	H	I	J	K
1	17/04/2013	17/05/2013	17/06/2013	17/07/2013	17/08/2013
Sheet1

 

[sanmaya]

Thanks a lot.