Don't use "Merged" cells!

Use "Center Across Selection" instead.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"elusiverunner" wrote in message
...
Thank you for your replies - unfortunately I neglected to mention that the
formula is in a cell that is spread across to cells that are merged and the
cell that I want to put a copy of the total is in only a portion of the two
cells that the original result is in.
When I try to use your methods all I get in the cell that is supposed to be
a copy is "0.50"
--
Steven.

In God we trust, all others we virus scan.