What's the secret to doing this I can't find nothing on it?

I need to execute a macro that will involve using data from the row
that is selected. I don't want to write 50 macros with 50 buttons. It
seems there would be a way of having a macro assigned to a cell in row
1. Then copy and paste it all the way down the column.

The other way would be to have the user make a selection, basically
highlighting the data, then pressing a button to execute a macro. The
problem for me is, I don't know how the macro will know which row,
column or cell is selected.

Please help. I'm stuck.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=518403