ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy Range while CutCopyMode=xlCopy (https://www.excelbanter.com/excel-programming/396624-copy-range-while-cutcopymode%3Dxlcopy.html)

bstobart

Copy Range while CutCopyMode=xlCopy
 
Where can I find the "copy range" (meaning the range of cells being copied)
after a user has pasted? At that point the Paste Range should be the
Selection, but I'm not sure where to find the range of cells that was just
copied.

Also, if a user is copying data from somewhere other than from a cell, say
from MS-Word, a webpage, or anywhere else, is there a way to identify that
location, or save the clipboard contents somewhere, so that if I need to
clear the clipboard, I can subsequently still get back to the data being
copied.


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com