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