Macro cell references
Closed
Hi there
I need to create a macro to increment a cell by one each time it is run...
However, the way this will work will be a button (with the Macro assigned to it) in one cell, and the Macro will need to refer to the cell in the previous column/same row as the Macro button and then increment it by one.
Is there any way macros can know from which cell they are being run from when they are being run from a button (rather than a shortcut).
I need to create a macro to increment a cell by one each time it is run...
However, the way this will work will be a button (with the Macro assigned to it) in one cell, and the Macro will need to refer to the cell in the previous column/same row as the Macro button and then increment it by one.
Is there any way macros can know from which cell they are being run from when they are being run from a button (rather than a shortcut).
Related:
- Macro cell references
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Based on the cell values in cells b77 - Excel Forum
- Count if cell contains number - Excel Forum
- Cell phone battery reset code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Aug 2, 2010 at 08:58 AM
Aug 2, 2010 at 08:58 AM
Is this same as your previous question as
https://ccm.net/forum/affich-68115-vba-macro-move-to-cell-underneath-the-button#5
https://ccm.net/forum/affich-68115-vba-macro-move-to-cell-underneath-the-button#5
Aug 2, 2010 at 11:03 PM