Hi-
Worksheets("sheet3").Range("a1:h1") = ActiveCell([1, 8] to [1, 15])
How would you take info from from cells on sheet1.activecell.offset(1 ,8) plus each of the next 7 cells to the right (.offset(1, 15)) and paste it on sheet3.range("a1:h1")?
In addition, if range (a1:h1") on sheet3 has info in it's cells, then the next pasting of cells from sheet1 has to go to the next available row, where there is blank cells.
[a1].End(xlDown).Offset(1, 0).Select
Im assuming this statement has to be added into the code, however im not sure where?
Thanks-
Worksheets("sheet3").Range("a1:h1") = ActiveCell([1, 8] to [1, 15])
How would you take info from from cells on sheet1.activecell.offset(1 ,8) plus each of the next 7 cells to the right (.offset(1, 15)) and paste it on sheet3.range("a1:h1")?
In addition, if range (a1:h1") on sheet3 has info in it's cells, then the next pasting of cells from sheet1 has to go to the next available row, where there is blank cells.
[a1].End(xlDown).Offset(1, 0).Select
Im assuming this statement has to be added into the code, however im not sure where?
Thanks-