If zero would not occur in the valid data to which you are linking then
you could just use a number format to suppress the appearance of zeros
coming from the empty cells. Select the destination cells and give
them a custom number format such as 0;-0;


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup