Altering Large Numbers Of Cells In Excel A Hundred Times Quicker

Many processes need to write large volumes of data in Excel.  The typical method is to loop through each cell and perform the action.

Rather than writing the values out cell by cell, it is quicker to store the value in an array and write the array to a range of cells at one time.

This same method can be used when altering data.  By changing the following line

To this

By using TheRange(i, j), the existing value can be altered


The process of writing values cell by cell took 3.16 seconds.  Using the array method, it took .08 seconds, nearly 40 times faster

Please follow and like us:

Leave a Reply

Your email address will not be published. Required fields are marked *