Thread: Macro to copy down large number of formulas

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

Welcome to the board. Are you just selecting the cells and dragging them down? This can be a bit tedious if there's quite a few cells so here's a trick to do this quickly.

I will use an example of copying formulas from cells A1:F1 down to row 2000.

1) Select Cells A1:F1
2) In the Home Ribbon menu, select Find and Select > Go To
3) Hold down the shift key then enter F2000 in the box that appears. Always enter the rightmost column you selcted and the desired last row.
4) In the Home Ribbon menu, select Find and Select > Fill > Down

All done.

regards,
Graham

Forgot to add, if you still want a macro then perhaps post your existing code / upload a copy of the workbook (after removing sensitive info like any customer details)

cheers,
Graham