Copy "active"

[al]

Can anybody help me in getting a macro for the excel copy function.
I would like the copy "application" to remain active even after I have
inserted a sheet or done something else before pasting what has been
copied.
Thxs

 

[Norman Jones]

Hi Al,

Try changing the macro so that the copy / paste operation is either
completed before another action clears the clipboard, or is performed after
such action.

 

[al]

How can i prevent another action from clearing the clipboard.
Thxs

 

[Norman Jones]

Hi Al,

How can i prevent another action from clearing the clipboard

I am not aware that you can.

As, I suggested, run the copy / paste before or after the action which
clears the clipboard..