I Don't Want to Click and Drag

[Parra]

I am importing data into Excel columns A through M. I add formulas to rows N through P. Is there a macro, to copy the formulas in N:P till the end of rows A:M?

Please help, Thanks.

 

[Derek]

Hi
If you are only putting formulas on the first row, you can copy those formulas down by selecting them and dragging the fill handle downwards. If you do this whilst using the macro recorder you can then go to the VB Editor (Alt+F11) and see the code.
hope this is what you were after.
regards
Derek