Transfer data by defined name
If you know the size of the range:
sheet2.range("C3:C6") = sheet1.range("MyRange")
If you don't know the size of the range:
For each cell in sheet1.range("MyRange")
sheet2.cells(3+cell.row,3+cell.column) = cell.value
Next cell
|