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



.