Altering Large Numbers Of Cells In Excel A hundred Times Quicker

Print
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:
RSS
Facebook
PINTEREST
LinkedIn
 

Leave a Reply

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