Button Name or Cell Reference
 

I have a sheet with 20 rows, at the end of each row is a button. If each
button calls the same macro, is there a way to know either which Button was
pressed (e.g. Button Name = "Button 1", or which Row or Cell Reference the
pressed Button was on?

I need to get the row number to process other code based on the row the
button was on.
--
Trefor

Button Name or Cell Reference
 

Hi Trefor,

See reponse to your later post

---
Regards,
Norman



"Trefor" wrote in message
...
I have a sheet with 20 rows, at the end of each row is a button. If each
button calls the same macro, is there a way to know either which Button
was
pressed (e.g. Button Name = "Button 1", or which Row or Cell Reference the
pressed Button was on?

I need to get the row number to process other code based on the row the
button was on.
--
Trefor