Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with pasting special merged cells to merged cells
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with pasting special merged cells to merged cells
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting into merged cells | Excel Discussion (Misc queries) | |||
(2003) Pasting into merged cells | Excel Worksheet Functions | |||
Pasting into merged cells | Excel Discussion (Misc queries) | |||
Macro Paste Special Merged Cells | Excel Programming | |||
pasting into merged cells with a macro | Excel Programming |