All,
I have a macro that copies two columns to a new workbook and a third row
adds up each cell in columns 1 and two. This script is part of a much
larger macro. The problem is that every now and then one of the cells that
is being copied over has a hidden space or character that causes the value
in column three to list #Value! instead of the correct amount. How can I
have the macro remove any hidden spaces/characters, etc so that when the
third column is adding up the two columns, I do not get the #Value! output?

Thanks

John