biocentrism
Board Regular
- Joined
- Jul 28, 2014
- Messages
- 187
Hello
I have a very, very large macro which does a lot of copying and pasting of ranges, creation of arrays from a database recordset and copy and pasting worksheets to the end of the workbook. The RAM usage can be in excess of 15GB. When I exit out of Excel, I get a prompt saying that there is a lot of data on the clipboard and do I want to save it.
I am surprised by this because I have at the end of the macro: Application.CutCopyMode = False.
My understanding is that this should clear the clipboard.
What am I doing wrong such that there is still data in the clipboard after the macro has run? How do I properly delete data from the clipboard?
Thank you.
I have a very, very large macro which does a lot of copying and pasting of ranges, creation of arrays from a database recordset and copy and pasting worksheets to the end of the workbook. The RAM usage can be in excess of 15GB. When I exit out of Excel, I get a prompt saying that there is a lot of data on the clipboard and do I want to save it.
I am surprised by this because I have at the end of the macro: Application.CutCopyMode = False.
My understanding is that this should clear the clipboard.
What am I doing wrong such that there is still data in the clipboard after the macro has run? How do I properly delete data from the clipboard?
Thank you.
Last edited: