Macro fill down formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marc Knowles - 20 Dec 2006 18:26 GMT

I have set up a macro to do a series of calculations automatically in
spreadsheets with various numbers of records. The macro uses the 'fill down'
command to apply the formulae to all records. What is the simplest way to
stop the fill down at the last record? I set up my macro using the 'record'
function in excel.

Thanks

Reply to this Message

Gord Dibben - 20 Dec 2006 19:51 GMT

Marc

Enter a formula in C1 then run this macro.

Sub Auto_Fill()
Dim Lrow As Long
With ActiveSheet.UsedRange
Lrow = .Cells(.Cells.Count).Row
Range("C1:C" & Lrow).FillDown
End With
End Sub

Gord Dibben MS Excel MVP

>I have set up a macro to do a series of calculations automatically in
>spreadsheets with various numbers of records. The macro uses the 'fill down'
[quoted text clipped - 3 lines]
>
>Thanks

Reply to this Message

Rate this thread: