Macro cell references

 Liam -
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).

1 reply

Registration date
Thursday January 28, 2010
Last seen
August 2, 2020
Yes it is... if you can help, can you do it on the other thread? Thanks...