Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone:
In excel 2003 VBA, I have a rather large 2D array. After doing some sorting and other things, I am trying to write the data back to the spreadsheet using loops. However, this writing take a bit too long, and is noticeable. All my work takes 35 msec, whereas writing it takes 923 msec. Is there a quick and fast way of dumping an array onto the spreadsheet? Thanks for your help, and here is my code for writing the data. 'N is the number or rows 'M is the number of columns c = M + 1 For i = 1 To N For j = 1 To M Cells(i, j + c + 1) = AOrig(ind(i), j) Next j Next i Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Writing inside the Cells also | New Users to Excel | |||
Writing to a range of cells | Excel Programming | |||
Writing to cells | New Users to Excel | |||
writing on cells | Excel Programming | |||
writing cells with variables from vba | Excel Programming |