How do I clear the copy buffer in VBA 1

[TheAceMan1]

Howdy All . . .

Excel 2003

Thru VBA ... there are times when I copy large amounts of data to the [blue]copy buffer[/blue]. I would like to be able to clear it to [blue]release the memory taken[/blue]. How can I do this?

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SkipVought]

hi,

Check out CopyCutMode.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TheAceMan1]

New PostSkipVought . . .

Roger That! ... (I just couldn't find anything that said false emptied the buffer). Testing proved this out ...

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]