Hi!

I have admins that are pasting numbers from one worksheet into cells on
another sheet. Some of the cells are blank, others have a zero value. They
are doing CopyPaste Special.

In the target worksheet, the cells they are pasting into are summed in a
column to create a total.

In some cases, the sum works fine, whether numbers, zero values, or blank
cells; in other cases, I get a #VALUE! error. When I go an audit the row
being summed, I may find several blank cells. I will add in a zero to the
blank cells and eventually, the error will go away and I will get a sum.
What is odd is that if I have, for example 8 cells, with only 3 having
numbers and 5 being blank, I may only have to add a zero into 1 or two cells
befoire the error disappers. There are still blank cells in the sum range.

Ideas?

Thanks!
--
Greg