Linking buttons with a row

[sl67]

If possible I would like to create using vba a button at the end of my rows of data allowing a user to copy and insert the row next to the button, i.e. duplicate.

I am using the following code to create the button but am not clear how to link a button to a row or cell. The button would be within a cell in a row at the end of the data.

Range("a2").Offset(rowoffset, 10).Select
ActiveSheet.Buttons.Add ActiveCell.Left, ActiveCell.Top, ActiveCell.Width, ActiveCell.Height

rowoffset increments within a loop and a button is placed at the end of each row of data.

I would also like to know how to name the button.

Have only been working with excel / vba a couple of week so coding is a little slow.

Any help would be appreciated

Thanks

[arlu1201]

It will be good if you attach your workbook along with the code so that we can understand your request better.