Paste Special-Paste Link problem

Andrew XJ · Feb 23rd, 2002, 08:40 PM

When i use Paste Special-Paste Links, all the blank cells in the source sheets are changes to 0 in the object cell. How to solve this problem? Please indicate.

Anne Troy · Feb 23rd, 2002, 11:34 PM

You will need to change your formula (link) after pasting from (for instance), =Sheet1!A1 to:

=If(isblank(Sheet1!A1),"",Sheet1!A1)

Andrew XJ · Feb 24th, 2002, 12:16 AM

Thanks! Dreamboat.
This works. ^_^. i should think of this. Previously i just thought of doing that in one step.

Feb 23rd, 2002, 11:34 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You will need to change your formula (link) after pasting from (for instance), =Sheet1!A1 to: =If(isblank(Sheet1!A1),"",Sheet1!A1) __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 23rd, 2002, 08:40 PM	#1
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	When i use Paste Special-Paste Links, all the blank cells in the source sheets are changes to 0 in the object cell. How to solve this problem? Please indicate.

Feb 24th, 2002, 12:16 AM	#3
Andrew XJ Board Regular Join Date: Feb 2002 Location: Singapore Posts: 77	Thanks! Dreamboat. This works. ^_^. i should think of this. Previously i just thought of doing that in one step.