is there any way to repeat a cell's formula other than clicking on the cell's corner and drag ?
=SUM(L14;M14)
=SUM(L15;M15)
=SUM(L16;M16)
=SUM(L18;M18)
... and more 3.000 times....
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
Range("A1").Copy Range("A3:A10")
Sub FillFormulas()
With ActiveSheet
Range("N14").Formula = "=SUM(L14:M14)"
Range("N14").AutoFill Range("N14:N3500")
End With
End Sub
Return to Macros and VBA Questions
Users browsing this forum: No registered users and 240 guests