temporary storage

R

Ralf schemm

Hi
when i copy and paste huge amounts off data and close the workbook
(everything by macro) my macro stopps and the assitstent ask my if i
still need the data in the temporary storage. How can i delete or
clear the storage by macro order??

Thanks for helping
 
P

Peter Eichler

Hi,


Application.DisplayAlerts = False
your code
Application.DisplayAlerts = True

peter
 
G

Gord Dibben

Ralf

Application.CutCopyMode = False

placed after your pasting step.

Gord Dibben Excel MVP
 

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

Need Help with Macro Security 1
Automation of scanned file storage based on content 0
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
profile storage 1
update templates: advice requested 0
Insufficient Memory or Disk Space. Close programs down? 0
Repairing Outlook PST using SCANPST.EXE 2

Top