There is a lagre amount of information on the Clipboard.

I have made this VBA programming that copys from a Excel sheet to another. But now I get this message "There is a lagre amount of information on the Clipboard. Do you whant to be able to paste this informationinto another program?".

How can a make to get an "automatic" - No, on this question?

Br Fredrik

This is the code;

Sub HamtaStoppTider()

Application.ScreenUpdating = False

ThisWorkbook.Sheets("Sheet2").Activate
Cells.ClearContents

Workbooks.Open "\\vcn.ds.net\rapporter\Exceldatabas.xlsm"
Range("A1").CurrentRegion.Rows.Copy
ThisWorkbook.Sheets("Sheet2").Activate
ActiveSheet.Paste
ThisWorkbook.Sheets("Sheet1").Activate
Range("A1").Activate
Workbooks("Exceldatabas.xlsm").Close 'savechanges:=False

   
Range("B10").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
Range("A1").Select
ActiveWorkbook.Save

Application.ScreenUpdating = True

End Sub