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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!