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