View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lester Lester is offline
external usenet poster
 
Posts: 1
Default Clearing ClipBoard in EXCEL

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