In Excel macros I would like to change a reference cell incrementally each time I do a button click. How would I do that? For example start out referencing cell b6 then one button click reference cell b7 and so on as often as I push the button it would increase the cell reference to the next vertical cell.
Software/Hardware used:
ASKED:
February 28, 2013 8:25 PM
UPDATED:
February 28, 2013 8:32 PM