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