Speed question: which is faster: loop to add formula, or fill-down?

[Gingertrees]

I currently have a macro set up that loops through used rows to add a different formula to column A, B, C, D, and E. So it applies the formula to A3, then another formula to B3, etc. to E3. Then it loops and does the same to A4, B4, etc. to the end of range.

Is this the fastest way, or would it be better to figure out the "FillDown" method for each column?

Simply an academic question. Formulas include:

• Concatenate 2 cells
• worksheet function of Vlookup
• worksheet function of CountIf
• Select Case.Value with 3 cases (was a nested IF-THEN statement before I wrote it into VBA; I'd return it to that if the concensus is that fill-down is faster)

PS: I already turned off screenupdating and Display Alerts for this routine.

 

[mumps]

I would think that fill down is faster.

 

[RoryA]

FillDown should be much faster, especially if you turn off calculation while adding the formulas and turn it back on at the end.

 

[Gingertrees]

(groan) I was afraid of that. OK, rewriting everything shall commence. Thanks for the responses, guys.