Kenneth,
Using his code would your suggestion change his code as follows?
How do you get the command button to appear on the line the user selects?With tbl For i = ActiveCell.Row To ActiveCell.Row ' <<your change For j = 1 To 5 .Cell(i, j) = wks.Cells(i, j) Next j Next i End With
Thanks,




