Macro cell references

Liam - Aug 1, 2010 at 10:18 PM
 Liam - Aug 2, 2010 at 11:03 PM
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 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
Yes it is... if you can help, can you do it on the other thread? Thanks...