Selecting cells based on button location

[Jon.R]

Hello, a bit of an excel noob here, any help much appreciated!

I have (automatically generated) buttons that all need to reference the same macro. This macro needs to remove a range of cells based on the button's position... I have come across this code:

Please Login or Register  to view this content.

Which works PERFECTLY for the first button created, however I need the button to be copied and pasted several times (a single macro to be able to be called)... does anyone know if this is possible in VBA? I was hoping for something like:

This.Button.Topleftcell ...

Again, any help much appreciated!

[StephenR]

You can assign each of the buttons to this macro:

Please Login or Register  to view this content.

[Jon.R]

Thanks! Perfect!