View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
okaizawa okaizawa is offline
external usenet poster
 
Posts: 129
Default 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