anyanka
One way:
Sub CopyToMergedCells()
For i = 1 To 3
Cells(i, 3) = Cells(i, 1)
Next
End Sub
Regards
Trevor
"anyanka " wrote in message
...
Hi, i'm totally new at this, but i really want to learn!
My problem at the moment is, when i try to paste data from, let say, 3
cells (A1:A3) in to 3 merged cells (C1:C3) through a macro, it keeps
saying "cannot paste in merged cells".
what can I do about that? The merged cells have to stay like they are
and I have to get the data in there!
Thanx
---
Message posted from http://www.ExcelForum.com/