Copy "active"
 

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

Copy "active"
 

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.

---
Regards,
Norman



"al" wrote in message
oups.com...
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

Copy "active"
 

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

Copy "active"
 

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..


---
Regards,
Norman



"al" wrote in message
ups.com...
How can i prevent another action from clearing the clipboard.
Thxs