Quicker way to loop than using Do Until and Activate

Hi,

I've built a loop that seems to be pretty slow. I know there are quicker solutions and I was hoping someone can help me out. Its a pretty simple set of code:

Please Login or Register  to view this content.

It basically adds 10 empty rows under the active cell and adds a formula 8 columns to the right and then moves 11 rows down and repeats. There are typically 500+ rows of data. It takes 2-3 minutes to get through the macro. I'd like it to be quicker. Thanks for the help!

You might try to avoid the use of cell activation by using range objects only

Please Login or Register  to view this content.