Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The cell address of a button?
I have a worksheet with data from each month arranged in
rows. For example, Rows 1-5 have January data, row 6 is blank, Rows 7-12 have February data, etc. In the first row of each month's data (in Column E), I have a button that allows the user to erase the data only for the month associated with the button. Is there any way to determine where (Row and Column address) this button is? On different sheets, the buttons may be at Row 10, 20, 30... for example. I would like my macro code to determine where the button is and delete only the CurrentRegion. Thank you so much for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Global Address List after clicking E-mail button in Excel 2003 | Excel Discussion (Misc queries) | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
How do I create a submit button to an email address in excel? | Excel Discussion (Misc queries) |