Managing Cut/Copy & Paste During Program Run

[Cory Layman]

I have a couple programs that make use of copy and paste during code
run to move around entire rows or columns. The problem I run into is
that the programs might run for an extended period of time so, the
user has time to work on other things during that period. However,
while the code is running, the user loses the ability to copy and
paste because the program is hitting the clipboard buffer.

My question: Is there a way to do a cut/copy&paste where VBE use a
clipboard buffer seperate from the system-wide clipboard buffer the
user would be utilizing? Any work around I've been able to dream up
so far would be horribly slow and cumbersome.

Thanks,

Cory

 

[GS]

Cory Layman brought next idea :

I have a couple programs that make use of copy and paste during code
run to move around entire rows or columns. The problem I run into is
that the programs might run for an extended period of time so, the
user has time to work on other things during that period. However,
while the code is running, the user loses the ability to copy and
paste because the program is hitting the clipboard buffer.

My question: Is there a way to do a cut/copy&paste where VBE use a
clipboard buffer seperate from the system-wide clipboard buffer the
user would be utilizing? Any work around I've been able to dream up
so far would be horribly slow and cumbersome.

Thanks,

Cory

When your code is done with each cut/copy/paste, try clearing the
clipboard so it's empty...

Application.CutCopyMode = False