Finding Row or Button Name
Hi Trefor,
Or, to return the row (as you asked) rather than the address:
'==============
Sub Tester()
MsgBox Application.Caller
MsgBox ActiveSheet.Buttons(Application.Caller). _
TopLeftCell.Row
End Sub
'<<==============
---
Regards,
Norman
"Trefor" wrote in message
...
If I have a sheet with 20 buttons (1 on each row) and each button points
to
the same macro, is it possible for the macro to determine the Row number
(Or
possibly the Button Name)?
Based on the row, the macro will continue updating data on that Row.
--
--
Trefor
|