Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "paste link", and "transpose" at the same time? | Excel Discussion (Misc queries) | |||
What are the reasons for ""ActiveSheet.Paste Link:=True"" failure | Excel Programming | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Error in Macro: "Method 'Paste' of object '_Worksheet' failed" | Excel Programming | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming |