Tag Archives: write array

Modifying spreadsheet data with VBA – the quick way

Posted on 25/04/2012 by dougaj4

A question recently came up (here) asking how to speed up the process of scanning a large range of data on one sheet, and wherever a cell had a value of zero, deleting the data in the same cell address … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , | 1 Comment

More on writing arrays to the worksheet

Posted on 28/09/2011 by dougaj4

Writing a large VBA array to the worksheet in a single operation, rather than cell by cell, can result in a huge improvement of the speed of many macros.  The basic technique was described here.  I recently wanted to modify this … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , | 3 Comments