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.