Referencing an object containing a macro while that macro is running

[jsireci]

Hello!

I'm using a shape to contain a delete function for a particular row of data. Since there are multiple delete shapes cooresponding to different rows, I need to use the activated shape's position data to determine which row needs to be deleted.

I can't figure out how to call the shape that has initiated the macro. Any ideas?

Thanks!

 

[AlphaFrog]

Application.Caller will return the name of the object that called the macro.

This will reference the Shape object that called the macro.

ActiveSheet.Shapes(Application.Caller)

 

[jsireci]

Perfect! Thank you!