array performance

  1. V

    Looping through an Array to load cells has slow performance

    I have a 7x2 array with integer values in the first dimension and column # stored in the second. Below I've looped through the array to load 7 cells, but performance takes a HUGE hit. For i = 1 To 7 Cells(ActiveCell.Row, sngArrayCT(i, 2)) = sngArrayCT(i, 1) Next iI've read...

Some videos you may like

This Week's Hot Topics