So the layout, is that I have several macro-buttons on my worksheet.
the one in question inserts several new rows above it, when clicked. The macro requests the topleftcell from the button that was clicked in order to determine the location of the new rows to insert.
This button was created using the Controls > Insert > Form Controls: Button
(not the ActiveX Control button)
When I control+click on the button this macro is assigned to, I can see that it has the name "Button 13"
I have tried searching around various forums, but those have only resulted in a runtime error, or "can not find shape with that name" errors.
Anyone have any ideas?
The end-goal is to be able loop the click command 100+ times, to make sure that the naming convention built into the macro works all the way.
Bookmarks