Silent running
 

Hello all,
Sorry to bother you with such a simple one but this is
driving me crazy - What's the vba equivalent of SWITCH
ECHO OFF to run a macro without the display?
regards,

Silent running
 

"Stewart" wrote in message
...
Hello all,
Sorry to bother you with such a simple one but this is
driving me crazy - What's the vba equivalent of SWITCH
ECHO OFF to run a macro without the display?
regards,

Hi Stewart,

Application.ScreenUpdating = False

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *