MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Paste Link Command

Posted by Jan on December 28, 2001 11:12 AM

I'm trying to reference information from a master list to a separate worksheet. the information is text and has some blank cells. The problem is that when i copy the info and then use the <paste link> command on the separate worksheet the blank cells from the master list are filled with a zero on the reference sheet. Is there any way around this?????


Posted by JACK IN UK on December 29, 2001 2:20 PM

Hi Jan--
I would after the code has runor the paste compleated
Tols/option/ show zero UNCHECK
eed to do on both or select all sheets in code. If code Array te sheets will be quicker


Posted by Jan on January 02, 2002 7:37 AM

Thank you That is exactly what i needed !! .