To give you more complete information, I am trying to copy E7:E46 to C7:C46.
And cells C7 & C8 are merged as are C9 & C10, etc. The column E cells are
identically merged. I hope this helps.

"ritpg" wrote:

dThanks for the response. Is what you propose a macro that I need to create?

Can you please provide some additional information? How do I enter it? How
do I execute it? I suspect I will nee to adapt it to my actual spreadsheet.

Again, thanks for your help.

ritpg

"Project Mangler" wrote:

ritpg,

using excel 2003:

Sub Toggle()
Dim ma As Object
Dim mb As Object
'B4 & B6 are first cells in respective merge areas
Set ma = Range("B4").MergeArea
Set mb = Range("B6").MergeArea
mb.Cells(1, 1).Value = ma.Cells(1, 1).Value
End Sub

HTH

"ritpg" wrote in message
...
I see several posts on this topic but none recently and I have yet to
find a solution. I am pasting special from a cell that consists to
two merged cells to another cell in the same row that also consists of
two merged cells. The columns are labeled Previous Month's Total and
Current Month's Total so you can see what I'm trying to do.
Interestingly, the problem seems to occur only when I'm doing a paste
special Values. I have to do Values because the cell in the Current
Month's Total contains an equation which I do not want to move to the
cell in the Previous Month's Total column - I just want the value.
Dr. Excel, are you still out there? Anbody else have a clue? I'm
running MS Excel 2003 under XP.
Thank you very much!


.