I have written a macro that copies and pastes a number of large chunks of
data. However I sometimes get an "Out of memory" message from Excel and
wondered if this is anything to do with the clipboard being full?

If this is the case, is there an easy way to empty the clipboard/stop this
error?

Thanks,

--
BT

Here is a link to everything you ever wanted to know about memory...

http://www.decisionmodels.com/memlimits.htm
--
HTH...

Jim Thomlinson


"BTrumble" wrote:

I have written a macro that copies and pastes a number of large chunks of
data. However I sometimes get an "Out of memory" message from Excel and
wondered if this is anything to do with the clipboard being full?

If this is the case, is there an easy way to empty the clipboard/stop this
error?

Thanks,

--
BT

Thanks Jim,

The site proved useful and helped convince me that I'm not going mad!

Regards,

--
BT


"Jim Thomlinson" wrote:

Here is a link to everything you ever wanted to know about memory...

http://www.decisionmodels.com/memlimits.htm
--
HTH...

Jim Thomlinson


"BTrumble" wrote:

I have written a macro that copies and pastes a number of large chunks of
data. However I sometimes get an "Out of memory" message from Excel and
wondered if this is anything to do with the clipboard being full?

If this is the case, is there an easy way to empty the clipboard/stop this
error?

Thanks,

--
BT

application.cutcopymode=false will clear the normal clipboard.

also make sure the office clipboard is not gathering data..

(check the options button at the bottom of the taskpane.
UNCHECK collect without showing the office clipboard")

and make sure the office clipboard is not showing.

automating the office clipboard is a mess.
I've just disabled the darn thing completely.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


BTrumble wrote :

I have written a macro that copies and pastes a number of large
chunks of data. However I sometimes get an "Out of memory" message
from Excel and wondered if this is anything to do with the clipboard
being full?

If this is the case, is there an easy way to empty the clipboard/stop
this error?

Thanks,