Currently, I have a button on a spreadsheet that when pressed, runs a macro that grabs a template file and copies it to another location and renames it based on the value that is located, in this case, cell A3. What I'm trying to do is figure out how to change the specific cell location (A3), with some sort of variable that instead allows the code to always select column A's cell with relation to which row the button is located in.

This form is going to have around 100-200 buttons all doing the same thing for each row that they are associated with. I'm just trying to avoid writing 200 different macro's for each one.

Hopefully this is an easy one. I appreciate any help that any of you can give.


sPath = ThisWorkbook.Path & "\" & Sheets(ActiveSheet.Name).Range("A3").Value