how eliminate zeros in blank cells using paste link
 

"pastelink" in excel 2003: blank cells in source worksheet become zeros
in detination worksheet. how can i eliminate them. thanks very much

One way:

=IF(Sheet2!$C$2="","",Sheet2!$C$2)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"sea kayaker" <sea wrote in message
...
"pastelink" in excel 2003: blank cells in source worksheet become zeros
in detination worksheet. how can i eliminate them. thanks very much

Method 1. Hide the zeros using ToolsOptionsView. Uncheck "zero values"

Method 2. Use an IF formula in the linked cells.

=IF(ISBLANK(Sheet1!A1,"",Sheet1A1)

If you have a great whack of these, after you paste the links, run this macro
on the selected range.

Sub ISBLANK_Add()
Dim myStr As String
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = True Then
If Not cel.Formula Like "=IF(ISBLANK*" Then
myStr = Right(cel.Formula, Len(cel.Formula) - 1)
cel.Value = "=IF(ISBLANK(" & myStr & "),""""," & myStr & ")"
End If
End If
Next
End Sub


Gord Dibben Excel MVP


On Sat, 16 Apr 2005 13:03:01 -0700, "sea kayaker" <sea
wrote:

"pastelink" in excel 2003: blank cells in source worksheet become zeros
in detination worksheet. how can i eliminate them. thanks very much