View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default cell formatting won't update

"Dave Peterson" wrote:
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.


Good point, Dave. Perhaps the precaution (if at all necessary) should be
just to clear the selected "empty" cell instead (press Delete key) before
copying it.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---