You have to use xlPasteValuesAndNumberFormats to carry the format over to the
new location also. Otherwise the Excel default takes precedence and treats
"" as zero for a value.

"DonJ_Austin" wrote:

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