Duplicating Macro & Changing Reference/Name

[Voluntondile]

Hey folks,

Hopefully this is pretty straight-forward. I can't seem to figure it out.

I have this bit of code for a short macro to be run on a button push:

Please Login or Register  to view this content.

Basically I'd like to make a couple hundred copies of this Macro, 1 to be used for each button. Obviously each one would need a new name (AddItem2, AddItem3, so on) and the only reference I need changed is that row number (32 in this case).

As an added bonus if anyone would know how to loop through all the form buttons on my page with name 'Add Item' and assign the macro to each one 1 by 1 in order that would be amazing. That part isn't too much work to do manually, however.

Totally open to any other solutions to go about this as well. Each button exists on a different row so I don't know if it's possible to find the current row number of a button and to change the 'D32' reference to the specific row number of the button pushed. That may be a lot easier as well.

Thanks so much!

[Voluntondile]

Nevermind, thanks. Figured it out!

Please Login or Register  to view this content.