View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trefor Trefor is offline
external usenet poster
 
Posts: 201
Default 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