Select column A's cell in relation to the row that macro button was clicked on?

[xlyfe]

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

[AndyLitch]

How about this

Please Login or Register  to view this content.

When you select column A it lifts the file name from the selected cell and runs the macro

[Norie]

How did you create the buttons?

If it's a Forms button you could use something like this.

Please Login or Register  to view this content.

Mind you having hundreds of buttons might not be a good idea.

[xlyfe]

How did you create the buttons?

If it's a Forms button you could use something like this.

Please Login or Register  to view this content.

Mind you having hundreds of buttons might not be a good idea.

Here is the whole button. And yes, it is a forms button.

Please Login or Register  to view this content.

Edit Post... I guess I'm just not sure how to incorporate what you suggested into what I've written so far. :/

Thank you for taking your time to help me out.

[xlyfe]

How about this

Please Login or Register  to view this content.

When you select column A it lifts the file name from the selected cell and runs the macro

I'm not actually ever selecting the row, but instead, clicking on a forms button that is placed almost perfectly within the the very last cell of the row that I'm going to be having it create a new sheet and pull data from.

I'm not even sure if what I'm trying to do is possible. This spreadsheet is kind of evolving as it's being created, thanks to the bosses continuous "what if's" after each updated revision.

I appreciate all of your guy's help on this. I really do.

[Norie]

Try this, which you should assign to each button.

Please Login or Register  to view this content.

[xlyfe]

Try this, which you should assign to each button.

Please Login or Register  to view this content.

This is working like a charm Norie. Thank you soooo much for helping me out with this. What I thought was going to be some difficult task, you made seem extremely easy. I envy, and welcome, your genius. Thanks again!