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.

Please Login or Register  to view this content.

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.

[LJMetzger]

Hi wayneg,

Try the following macro. Please note that your original code creates two Buttons.

Please Login or Register  to view this content.

I hope this helps.

Lewis

[wayneg]

thanks LJMetzger , works nicely