Hi,


When I mark/select a range of cells, I can see the SUM of all the cell
values in the statusbar (as you all probably know).

By right-clicking this SUM-field in the statusbar, I can also choose to
view MIN or MAX or some other calculation on the selected cells.

But, how to I set this programmically by VBA?

Say, the setting is set to show MAX, but I want to change it into
showing SUM - using VBA code...

How to do this?


Thanks,

CE