Copy buttons by rows

[Dave Peterson]

I had a mistake in today's code. I pasted to the bottom of sheet2 column A.
But then I didn't go to the next cell.

Option Explicit
Sub testme2()
Dim toWks As Worksheet
Dim actWks As Worksheet
Dim myRng As Range
Dim myCell As Range
Dim iRow As Long
Dim DestCell As Range

Set actWks = ActiveSheet
Set toWks = Worksheets("Sheet1")

Set myRng = Intersect(Selection.EntireRow, actWks.Range("a:a"))

With toWks
Set DestCell = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0)
End With

With toWks
For Each myCell In myRng.Cells
iRow = myCell.Row
DestCell.Value = actWks.Cells(iRow, "a").Value
DestCell.Offset(0, 1).Value = actWks.Cells(iRow, "z").Value
'I added this to go down one row.
Set DestCell = Destcell.offset(1,0)
Next myCell
End With
End Sub

It does assume that the cell in column A of the input worksheet is not empty!

 

[Optitron]

Ok it's working. It put the data on the next page down. It's all goo
now. Thanks.