I need to change the formula from SUM(A$2:A40) to SUM(A$2:A2) in several columns. Instead of having to use the mouse to click on the Calculator button each time I select a cell, I would like to use a macro to open the Calculator, leaving me poised to enter the new formula. But Excel does not allow me to Stop Recording the macro unless the Calculator box is closed.
Simply put, I need a macro that opens the Calculator (using relative cell references), so that I can immediately type in a formula and then click "OK" in the Calculator box. Any advice?
Bookmarks