VBA copy from single to merged cell.
 

I have a sub routine that calls information from one sheet and copies it
to another sheet in the same workbook. My problem is that hte
information that is coppied comes from a single cell and has to be
placed into a merged cell. The destination sheet is protected and
cannot be altered. I was wondering if anyone knows how I might go
about this. The code I use to copy information is:
Worksheets("sheet1").Range("L4:L8").Copy
Worksheets("wsheet").Range("X105:X109")

This is looped to copy the information to a total of 35 sheets.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=476691

VBA copy from single to merged cell.
 

errr. Nevermind I found the solution myself. For anyone intereste
it's as follows.

Worksheets("wSheet").Range("X105:X109").Value = _
Worksheets("Bubble").Range("L4:L8"

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=47669