How to pass location/range of button into a macro?

[Kelvin Stott]

Hello,

I hope everyone is well, and that at least one of you can please help...

I've created a button to run a macro, but need to pass the location/range of that button into the macro when it is clicked. Is there any way to do this so that the range is correctly identified when I move or copy the button to a different cell?

How do I identify the location/range of a specific button when it is pressed, if there are multiple copies of the same button?

Any help would be appreciated, thanks!

 

[RoryA]

If you are using Forms buttons rather than activeX then in your assigned macro you can use:

Activesheet.buttons(application.caller).Topleftcell

to refer to the cell under the top left corner of whichever button called the macro.

 

[Kelvin Stott]

Thanks Rory,

I created the button by assigning a macro to a picture, so I'm not sure how this could work?

 

[Norie]

Kelvin

Instead of Buttons you could try Shapes.

 

[Kelvin Stott]

Thanks mate,

I don't know what I'd do without you guys!