Hi,

I trying to get some code to run invisibly to the user. The code is:

WksSource.Range("testing").Copy
WksRaw.Range("A1").PasteSpecial xlPasteValues

This works fine but the user can see whats happening.

I've tried:

WksSource.Range("testing").Copy _
Destination: WksRaw.Range("A1").PasteSpecial xlPasteValues

but this won't allow the pastespecial method which is required. Is this a
syntax issue or is there some otherway I can copy and PastSpecial without
the code visibly switching between sheets.

Thanks in advance

Paul,
Application.ScreenUpdating = False
Donna

Paul,

Have you tried

application.screenupdating=false

before you run your code, then

application.screenupdating=true

at the end of the macro?

Hope this helps

Pete


"Paul" wrote:

Hi,

I trying to get some code to run invisibly to the user. The code is:

WksSource.Range("testing").Copy
WksRaw.Range("A1").PasteSpecial xlPasteValues

This works fine but the user can see whats happening.

I've tried:

WksSource.Range("testing").Copy _
Destination: WksRaw.Range("A1").PasteSpecial xlPasteValues

but this won't allow the pastespecial method which is required. Is this a
syntax issue or is there some otherway I can copy and PastSpecial without
the code visibly switching between sheets.

Thanks in advance

Thanks for the reply Donna,

I tried that but after

WksSource.Range("testing").Copy

I can see the range being highlighted for copying ( Same as if you Ctrl +
C). Even when the procedure ends the range remain highlighted

Any other suggestions?


wrote in message
oups.com...
Paul,
Application.ScreenUpdating = False
Donna

Paul,
instead of using pastespecial to copy the value just set the value of the
cell.

WksRaw.Range("A1").Value = WksSource.Range("testing").Value

Fred



"Paul" <paulm dot c @ iol dot ie wrote in message
...
Hi,

I trying to get some code to run invisibly to the user. The code is:

WksSource.Range("testing").Copy
WksRaw.Range("A1").PasteSpecial xlPasteValues

This works fine but the user can see whats happening.

I've tried:

WksSource.Range("testing").Copy _
Destination: WksRaw.Range("A1").PasteSpecial xlPasteValues

but this won't allow the pastespecial method which is required. Is this a
syntax issue or is there some otherway I can copy and PastSpecial without
the code visibly switching between sheets.

Thanks in advance

I can see the range being highlighted for copying ( Same as if you
Ctrl + C). Even when the procedure ends the range remain highlighted

application.cutcopymode = false

will remove that.

arno