Hi and thanks,
Data set
Col A Col B Col C Col D Col E Col F Col G
Row 1 x x x x x x x
<colgroup><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to copy each row separately ( baring in mind my data my not always start in row 1 so the row starting point is unknown. I need to do this until the last row so in this case row 4.
I am only able to do this if I know my starting row I am struggling to get this done when not knowing the starting row.
I have the code below
Data set
Col A Col B Col C Col D Col E Col F Col G
Row 1 x x x x x x x
Row 2 x x x x x x x Row 3 x x x x x x x Row 4 x x x x x x x |
<colgroup><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I need to copy each row separately ( baring in mind my data my not always start in row 1 so the row starting point is unknown. I need to do this until the last row so in this case row 4.
I am only able to do this if I know my starting row I am struggling to get this done when not knowing the starting row.
I have the code below
Code:
For i = 79 To LastRow
Range(i, Rng).Copy
Next i