G
Guest
I need to select the next row every time a CommanButton is pressed.
I need to start with row3, select it and copy it. The next time the
CommanButton is pressed, it will select the next and copy the next row (Row4)
and so on everytime the CommandButton is pressed.
This is what I have put together so far, but its not working.
Private Sub CommandButton1_Click()
Rows("2:2").Select
Cells(.Row + 1, 1).Select
Selection.Copy
End Sub
I need to start with row3, select it and copy it. The next time the
CommanButton is pressed, it will select the next and copy the next row (Row4)
and so on everytime the CommandButton is pressed.
This is what I have put together so far, but its not working.
Private Sub CommandButton1_Click()
Rows("2:2").Select
Cells(.Row + 1, 1).Select
Selection.Copy
End Sub