HI all ,

OK ... help here please ... you know when you write a visual basic programme
in Excel , and you want to take some information from "Sheet1" and do some
calculations with it and put it into "Sheet2" for example .. but you want to
do this calculation thousnads of times ... well what you see when you run it
is Excel flicking from Sheet1 to Sheet2 all the time ... is there any way of
turning that off ... like turning off that ... if you know what I mean ...
because it must slow the programme down having to display each sheet every
time ..

I am looking for a command like "AutoUpdate Off " does that exist ??

Thanks

Use:
Application.screenupdating=false



Francisco Mariscal
fcomariscal at hotmail dot com


-----Original Message-----
HI all ,

OK ... help here please ... you know when you write a
visual basic programme
in Excel , and you want to take some information
from "Sheet1" and do some
calculations with it and put it into "Sheet2" for
example .. but you want to
do this calculation thousnads of times ... well what you
see when you run it
is Excel flicking from Sheet1 to Sheet2 all the time ...
is there any way of
turning that off ... like turning off that ... if you
know what I mean ...
because it must slow the programme down having to display
each sheet every
time ..

I am looking for a command like "AutoUpdate Off " does
that exist ??

Thanks



.

yep you can turn off the updating

put the following at the beginning of your code

Application.ScreenUpdating = False
there is no need to set it to true as this is done automatically when macro
finishes.

you may also want to use the following if your spreadsheets contain lots of
formulas

application.Calculation = xlCalculationManual
this stops excel recalculating formulas each time it changes something -
however you do need to set this back to automatic at the end of the macro

application.Calculation = xlCalculationAutomatic

Hi Adrian,
Turning off screen updating (and calculation) will make a
tremendous difference. The fact that you have a lot of
screen refreshing though probably indicates that you are
changing the selection and or activecell.

Code produced by the macro recorder does not generally
produce efficient code. It usually changes the selections
and refers to specific cells. Use the recorded macro as
an aid for what instructions can be used, and look up
those instructions in VBE Help..

Once the new sheet is created is possible to refer to any
cell on either sheet without changing the sheet or the
cell selection.
http://www.mvps.org/dmcritchie/excel/code/bus_sched.txt

Some hints on better coding can be found in
Slow Response and Memory Problems
http://www.mvps.org/dmcritchie/excel/slowresp;.htm
and in
Proper, and other Text changes -- Use of SpecialCells
http://www.mvps.org/dmcritchie/excel/proper.htm

and in Charles William's site
Decision Models - Excel Pages - Calculation Secrets, Downloads and Tips
http://www.decisionmodels.com/optspeed.htm



--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote in message ...
Adrian,

There sure is. Precede your code with

Application.Screenupdating = False

and set it to True on exit.

--

HTH

Bob Phillips

"Adrian Tucker" wrote in message
...
HI all ,

OK ... help here please ... you know when you write a visual basic
programme
in Excel , and you want to take some information from "Sheet1" and do some
calculations with it and put it into "Sheet2" for example .. but you want
to
do this calculation thousnads of times ... well what you see when you run
it
is Excel flicking from Sheet1 to Sheet2 all the time ... is there any way
of
turning that off ... like turning off that ... if you know what I mean ...
because it must slow the programme down having to display each sheet every
time ..

I am looking for a command like "AutoUpdate Off " does that exist ??

Thanks