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?????

Thanks.


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

HTH
Jack

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

Thank you That is exactly what i needed !! .