VBA copy / paste

[Steve_in_Kent]

I'm using this sort of code, to copy from one worksheet to another.. it copies over ok... but, it then asks about ''you have copied a large amount of data to the clipboard.. do you want to.. etc..'' to which you have to click NO each time.

is there a way in the paste options to stop this message, (in vba i don't want to paste it elsewhere)

Code: Select all

FoundLine = 16
Backend = 999
   With wbkSource.Sheets("Daily")
         .Range("C" & FoundLine & ":" & "J" & Backend).Copy
    End With
With ThisWorkbook.ActiveSheet
    .Range("AP15").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End With

Thanks

steve

[HansV]

You can clear the clipboard by adding the line

Application.CutCopyMode = False

below the code that pastes.

[Steve_in_Kent]

cheers hans.. works a treat