Macro Speed

[BN-CD]

I have writen a macro that checks up to 20,000 lines of data for a few different variables. The macro works fine it just takes quite some time to run. (about 5-10 minutes) The macro checks for these variables by the use of formulas within the worksheet then copies the formula down the column as far as needed. When I wrote the macro I was new to VBA. I used this forum to get ideas and it helped a lot!! Thanks everyone!

Now here is the question-

Does anyone think the macro would run faster if instead of putting a formula within the worksheet have tha macro work it out and loop through the sheet.

OR

Could it possibly run faster if I were to use a loop to copy the formula to each cell 1 row at a time?

I'm guessing these ideas will not prove faster just because I'll still have to loop through some 20,000 rows of data but I wanted to get some of your opinions as I'm still a noob and thought it would be best to ask the experts.

[Conor]

if you are writing back to the spreadsheet, turn screen updating off and see how that works for you.

[BN-CD]

I have turned off screen update. It helped a little but not all that much. I think most of the time is being eaten up by calculating all the formulas that are being copied.
Thanks for the suggestion though