Touble copying from single cell to merged cell

[Chumo82]

Ok, here is my problem…

I am trying to copy from a single cell from worksheet1 and place it in a merged cell in worksheet2. I don’t want to have the borders copy over just the values but I always get error about the cells not being the right size. I have also tried PasteSpecial and have it paste everything but the borders but the just breaks down the merged cell when it is pasting so I can’t use that. I guess the question is does anybody have any ideas on how to copy from a single cell to a merged cell without keeping borders or breaking the merged cell apart?


Here is a piece of what I am trying to do but I just can’t get the formatting correct.


Worksheets("Master&quot.Cells(counter, 8).Copy
Worksheets("RCCA&quot.Range("G16:I16&quot.PasteSpecial (xlPasteAllExceptBorders)

Thanks in advance.

 

[xlbo]

Seems like excel doesn't like copying to merged cells - do you have to copy ??
can you not just take the value and place it ??

Worksheets("RCCA&quot.Range("G16&quot.value = Worksheets("Master&quot.Cells(counter, 8).value

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[Chumo82]

I tried this but it does not appear to display the value in the worksheet I need it in. At first I thought it was just backwards but when I try different things I never get an output. Maybe I am missing something (unfortunately I am just learning VBA). Is there a way other than this to place a value to another cell???

 

[Chumo82]

I figured it out. Your code was perfect I was just being stupid and didn't change cell ranges. Thank You for the help.