Copy range of cells from sheet to another sheet using offset

Hello,

How can I use offset to copy a range of cells sheet1.range("C2:G2").value to sheet2.range("B8") using offset and also Cell B8 is a merged cell.

If you are trying to combine the values of "C2:G2" in B8 then just put the following formula in cell B8.

Please Login or Register  to view this content.