Hi All!

I a complete newbie to this vba programming and through my research of topics it appears that each thread is tailored specifically to the request, which is great. However, I am trying to take bits and pieces from each and having trouble compiling my own code. I am trying to insert three rows below the last data line in column A and copy and paste the previous formulas to the inserted rows. In addition, the data in column A consists of dates and I would like to program the Macro to auto-fill these dates.

As an example:

A B C D

1 01/30/12 Formula A Formula B Formula C

2 02/29/12 Formula A Formula B Formula C

3 03/31/12 Formula A Formula B Formula C

4 04/30/12 Formula A Formula B Formula C

5 05/31/12 Formula A Formula B Formula C

6 06/30/12 Formula A Formula B Formula C

Therefore the end would result would be the data above and:

A B C D

7 07/31/12 Formula A Formula B Formula C

8 08/31/12 Formula A Formula B Formula C

9 09/30/12 Formula A Formula B Formula C

And then so on, everytime i run the macro

10 10/31/12 Formula A Formula B Formula C

11 11/30/12 Formula A Formula B Formula C

12 12/31/12 Formula A Formula B Formula C

I apologize in advance if this is a very elementary request and appreciate any insight that can be given.

Thanks,

Jlee

## Bookmarks