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.