Problems with Paste
okaizawa wrote:
Hi,
first of all, this 'Copy' method doesn't store cell value
to clipboard but only the address of range.
(actually text data is stored, however, it is not used
when we paste into cells.)
if you want to store cell value and restore it, you should copy it
onto another cell range or variables.
Sorry, I withdraw my previous post.
I have not tested it enough.
the problem is that changing cell clears clipboard.
so, better to copy onto another cell range.
--
okaizawa
|