When you Paste Link, it creates a reference to the original cell.
For example: =A1
You can modify the formula: =IF(A1="","",A1)
shertay wrote:
How do paste links from one worksheet to another worksheet in the same
workbook with out it changing info or adding "0" in blank cells.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html