Macro cell references

Closed
Report
-
 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

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