Clear clipboard memory

  • Thread starter Thread starter John
  • Start date Start date
J

John

After running the following, how do I keep the message of "Do you want to
keep the large amount..blah blah" Yes No Cancel?

Dim bk as Workbook
set bk = Workbooks.Open( Filename:="C:\temp\jul 07.xls")
bk.Worksheets(2).Range("B216:Y242").Copy

ThisWorkbook.Activate
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Thanks,
John
 
Sorry...not sure quite what you mean...do you want the message to come up or do you want to clear the clipboard?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying range from selected workbook to open workbook 2
Suppressing a screen 2
Works in module but not in project 2
conso macro 0
Windows error 4
Windows XP Office 2003 Run-time error '9' 2
Saving a workbook - vba 1
Run macro from active workbook whose name keeps changing 20

Back
Top