Hello,

I need help.
I got a memory problem in excel caused by a VBA module using the
command copy(cntl+C) in a loop.
Is there any way in VBA to clear the Excel clipboard in
my loop before getting the memory problem
or a way to copy a cell, paste it and clear
the copied cell out from the clipboard

Thanks & sorry the way i write english

MarioB

I think this does it

Application.CutCopyMode = False

But then again, I am no expert.

Lester

On 6 Dec 2004 12:46:26 -0800, (MarioB)
wrote:

Hello,

I need help.
I got a memory problem in excel caused by a VBA module using the
command copy(cntl+C) in a loop.
Is there any way in VBA to clear the Excel clipboard in
my loop before getting the memory problem
or a way to copy a cell, paste it and clear
the copied cell out from the clipboard

Thanks & sorry the way i write english

MarioB

It sounds as if I am trying to do the same thing. Did the
"application.cutcopymode = false" work for you?

I have a copy in a loop and it will will work just fine for about 21 copies.
It will then give me an error saying copy command will not work???? But it
did do 21 of them.

Let me know what you did to solve your problem

thanks for any help

Carter

"MarioB" wrote:

Hello,

I need help.
I got a memory problem in excel caused by a VBA module using the
command copy(cntl+C) in a loop.
Is there any way in VBA to clear the Excel clipboard in
my loop before getting the memory problem
or a way to copy a cell, paste it and clear
the copied cell out from the clipboard

Thanks & sorry the way i write english

MarioB

Carter,
Not sure if this will make a differences, but you can turn off the Office
clipboard:

http://support.microsoft.com/default...;en-us;Q207438

NickHK

"Carter" wrote in message
...
It sounds as if I am trying to do the same thing. Did the
"application.cutcopymode = false" work for you?

I have a copy in a loop and it will will work just fine for about 21
copies.
It will then give me an error saying copy command will not work???? But
it
did do 21 of them.

Let me know what you did to solve your problem

thanks for any help

Carter

"MarioB" wrote:

Hello,

I need help.
I got a memory problem in excel caused by a VBA module using the
command copy(cntl+C) in a loop.
Is there any way in VBA to clear the Excel clipboard in
my loop before getting the memory problem
or a way to copy a cell, paste it and clear
the copied cell out from the clipboard

Thanks & sorry the way i write english

MarioB