Using Excel, how to trap the copy/paste object?

mshaffer 0
Viewed 17

One can copy/paste into and out of Excel. It seems like there is a basic \n and \t tab protocol that is being followed.

  • How exactly could I peek inside to see the mechanics?
  • Do those mechanics change on OS as copy/paste is an OS event?
  • How do they change in a web setting (e.g., copy from Excel 2010 to a cloud version)?

Fundamentally, this question arises because within Excel if you copy/paste it will update the REFERENCES of your formulas. That tells me that under the hood, it captured during copy and paste the attributes of the CELLS?

  • How to peek inside the attributes of the CELLS being copied and pasted (the FORMULAS)?
  • Is it encrypted so it can't be viewed?

Question: Using Excel, how to trap the copy/paste object?

export-to-excel copy-paste excel-2010 excel-formula excel
1 Answers

Are you aware that in Windows, you can use the Start+V shortcut to see the content of the clipboard? This is accessible throughout your entire Windows session, not only Excel.

... or are you looking for a way to access this information from inside Excel? In that case, you might need to extend your VBA with following reference:

enter image description here

Dominique0
Related