VBA button create from a macro

[wayneg]

Hi all,

I need a macro that will look for the last cell with info in in column D and then checks if the corresponding cell in column E has a macro button there, and if not copy one and paste a button in there.

    ActiveSheet.Shapes.Range(Array("Button 258")).Select
    Selection.Copy
    Range("E107").Select
    ActiveSheet.Buttons.Add(798.75, 2385.75, 57.75, 21).Select
    ActiveSheet.Paste

This is one that i recorded, but i need to amend it so it becomes dynamic and also so it checks to see if a button exist there already.