Yeah, but...

If you have empty cells in the "pasted" range, then you'll end up with 0's in
those cells (if you start with a cell with 0).

The blank (really empty) cell doesn't have this trouble.



Max wrote:

"Gord Dibben" wrote:
Just copy a blank/empty cell and Paste SpecialAdd
To save a few keystrokes, it is not necessary to enter the 0 in a cell.

Agreed, Gord. It was just a precaution to make doubly certain that the
"empty" cell selected for copy didn't contain any "invisible" white spaces.
i.e. it's really empty. One never knows which "empty" cell might get selected
over there <g.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

--

Dave Peterson