staffordalex
11-10-2008, 04:08 AM
Hi,
My code falls over when it tries to copy data from a single cell to a merged cell.
I was hoping someone might be able to shed a bit of light on the matter.
Here's my code:
ActiveSheet.Range("C10").Copy wb.Sheets("WorkstreamReport").Range("B15:C15")
C10 is a single cell
B15 is merged with C15
Thanks,
Alex
My code falls over when it tries to copy data from a single cell to a merged cell.
I was hoping someone might be able to shed a bit of light on the matter.
Here's my code:
ActiveSheet.Range("C10").Copy wb.Sheets("WorkstreamReport").Range("B15:C15")
C10 is a single cell
B15 is merged with C15
Thanks,
Alex