Visual Basic - Invisible Command
 

Hello,

I have some macros written in VB Script that opens 2 different workbooks,
selects cells from one and pastes/special/values to the other. There are
multiple tabs in the destination files. There are 4 different macros in the
project with each set to call the next one. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

Many thanks.
Chris

Visual Basic - Invisible Command
 

On May 28, 12:06*pm, Chris Stammers
wrote:
. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

You can hide it with application.screenupdating as suggested above.
However, it sounds like your macros are perhaps based on recorded
macros? Recorded macros always select cells then work on them, which
is inelegant and potentially problematical. Much better to refer to
cells and ranges directly.

eg, instead of
Sheet1.range("A2:B3").select
selection.copy

use

sheet1.range("A2:B3").Copy

Visual Basic - Invisible Command
 

Many thanks for your help Jacob. That worked perfectly!

Regards,
Chris

"Jacob Skaria" wrote:

Chris, in your main procedure disable the Screen updating..as below

Sub Macro()
application.ScreenUpdating = False

' your code

application.ScreenUpdating = True
End Sub
--
If this post helps click Yes
---------------
Jacob Skaria


"Chris Stammers" wrote:

Hello,

I have some macros written in VB Script that opens 2 different workbooks,
selects cells from one and pastes/special/values to the other. There are
multiple tabs in the destination files. There are 4 different macros in the
project with each set to call the next one. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

Many thanks.
Chris

Visual Basic - Invisible Command
 

Thank you. I'll try that as well.

Regards,
Chris


"andy the pugh" wrote:

On May 28, 12:06 pm, Chris Stammers
wrote:
. The script works fine however you
can see it flicking between each sheet as it is copying and pasting. Is there
a piece of code that will hide this? I am using Excel 2003.

You can hide it with application.screenupdating as suggested above.
However, it sounds like your macros are perhaps based on recorded
macros? Recorded macros always select cells then work on them, which
is inelegant and potentially problematical. Much better to refer to
cells and ranges directly.

eg, instead of
Sheet1.range("A2:B3").select
selection.copy

use

sheet1.range("A2:B3").Copy