View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DonJ_Austin DonJ_Austin is offline
external usenet poster
 
Posts: 19
Default Paste Method - Link: "" 0

I changed a PasteSpecial operation to Paste (with Link:=True) to accomplish
pasting a link. I know about fiddling with the object cited to get it to
work, and it does - sort of.

My question is why, in the results of the Paste link, does a space ("") in
the source cell become a zero (0) in the destination when the the
PasteSpecial faithfully copies the space ? Is there additional syntax in the
<iActivesheet.Paste Link:=True</i stetement that will cause the correct
copying of spaces ?

Thanks in advance.

-dj