FillDown vs Copy&Paste

[alee001]

Anyone know that what method will more efficient between using FillDown and Copy&Paste on range (over 10K rows)?
Is it need add Application.CutCopyMode = False after using FillDown?
Thanks.

 

[MARK858]

2nd question 1st, no you don't need CutCopymode false with Filldown.
1st question, what are you doing? If you are putting in a formula it is better to apply the formula to the entire range rather than use either.

 

[alee001]

2nd question 1st, no you don't need CutCopymode false with Filldown.
1st question, what are you doing? If you are putting in a formula it is better to apply the formula to the entire range rather than use either.

I used to copy formula then calculation in range, thanks.

 

[MARK858]

Not much detail there to go on but just as an example if you wanted to fill the formula down from B3 to the same row as the last row in column A then say you had the formula

=IF(C3<>"",SUMIF($C$3:$D$23,C3,$D$3:$D$23),"")

you would double any quotes and use the code below (Excel is smart enough to realise that you are filling a formula and will do any incrementation needed).

Sub Formula_Filldown()
    With Application
        .Calculation = xlManual
        .ScreenUpdating = False
    End With
    
    Range("B3:B" & Range("A" & Rows.Count).End(xlUp).Row).Formula = "=IF(C3<>"""",SUMIF($C$3:$D$23,C3,$D$3:$D$23),"""")"
    
    With Application
        .Calculation = xlAutomatic
        .ScreenUpdating = True
    End With
End Sub

 

[alee001]

I feel using FillDown faster than Copy&Paste without add Application.CutCopyMode = False to release ram?

 

[MARK858]

Filldown should be faster because it doesn't use the same number of clipboards as copy/paste, applying the formulas directly should be faster.