I am writing a 2-D array to an Excel spreadsheet by the following:
'Write data (number of entries per line = intWord
'and number of lines = intNpoints)
For i = 1 To intNpoints
For j = 1 To intWord
.Cells(i + 3, j) = dblData2(i, j)
When intWord = 37 and intNpoints = 41, it takes about 4 seconds on a 900 MHz computer. I know that VC++ can do it in a fraction of a second, but I am not a VC++ programmer. Is there a way to do it in VB 6 more quickly than the above code?