Posted to microsoft.public.excel.programming
|
|
Delay when writing cell information to Excel from VBA Macro
Gary,
Thanks alot. New to Excel macros - was stumped.
Dick HSV
"Gary Keramidas" wrote:
add
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
to the beginning of your code
and
Application.ScreenUpdating = true
Application.Calculation = xlCalculationAutomatic
at the end
--
Gary
"Dick HSV" <Dick wrote in message
...
When I loop through in VBA setting a value for a variable the loop goes
fast. When I use cell(i,j).value to put the value in a cell there is about a
1 second delay between each cell. For 250 cells it is a long wait. Is there
any way to control this wait?
|