Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
To reduce the speed of circulation in a range of cells
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
To reduce the speed of circulation in a range of cells
You can use the Timer function:
Sub ToggleCells() sleepTime = 1 'seconds 'toggle active cell 10 times For i = 1 To 10 If i Mod 2 = 0 Then Cells(1, 1).Activate Else Cells(2, 2).Activate End If Start = Timer Do While Timer < Start + sleepTime DoEvents Loop Next End Sub -- urkec "Jack clav" wrote: 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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reduce Fie Size, Speed Up Calculation | Excel Worksheet Functions | |||
How do I reduce the range of a saved worksheet? | Excel Discussion (Misc queries) | |||
library circulation function | New Users to Excel | |||
How do I turn around 'Circulation Reference' msgbox? | Excel Programming | |||
How to Reduce Spreadsheet Size and Speed | Excel Worksheet Functions |