View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Deborah Digby Deborah Digby is offline
external usenet poster
 
Posts: 6
Default To reduce the speed of circulation in a range of cells

try putting the information into an array then transferring the contents of
the array to the range. I assume you are using a loop to fill the range.
Loop through the array, then use a statement like:
Range("whatever") = myArray
(this approx 100 times faster than looping through a range)

Obviously, you need to work out the dimensions involved, Redim-ing
dynamically if necessary. Also if the array is one-dimensional you will need
to use application.transpose(myArray)

D



"Jack clav" wrote in message
...


Jeanmi
Hello,

I have made a program which circulates in a range of cells.
I would like to reduce the speed of execution. I would like that the
selection of the cells don't go so quickly.
Is it possible and what must I do?


Thank you in advance,


Jean-michel






*** Sent via Developersdex http://www.developersdex.com ***