Thank you both for your suggestions. I will test them out.


Bill Manville wrote:
A cell that appears to be empty may not be.

There is a difference between a completely empty cell and a cell
containing a null string. Select the cells and take a look at the
formula bar. If you see ' in the formula bar then there is a null
string in the cell, or if you see a formula such as =IF(A1=0,"",A1) and
A1 is 0 then the cell will contain a null string.

A further complication is the option to suppress display of zero
values. In that case a cell might appear empty but actually contain 0.

A link to an empty cell or a cell containing 0 will always produce 0.
A link to a cell containing a null string will always produce a null
string.

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

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via http://www.officekb.com