Recent Comments
Tag Archives: write array
Modifying spreadsheet data with VBA – the quick way
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
More on writing arrays to the worksheet
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
Newton Excel Bach, not (just) an Excel Blog 