I have a relatively large spread sheet with may columns of formulas. I want to write a macro to copy down these formulas down to line 2000 filling in all the lines in between. I need to do this every time i use the sheet so i want to write a macro to do this automatically instead of having to manually drag the formulas down each time.

I need to copy the first two lines down between columns AA an DT. I thought this would be really easy but when i try to do it all at once i get an error "selection too large". Any ideas about how to get around this.

Thanks for your help