Add Average Function to a toolbar with an exclusive icon?
Never have found such a button.
User could assign a macro to a button if the Autosom dropdown is too unwieldy.
Sub Average_Range()
Set rng = Selection
Set rng1 = rng.Offset(rng.Rows.Count, 0).Resize(1, 1)
rng1.Formula = "=Average(" & rng.Address & ")"
End Sub
Gord Dibben MS Excel MVP
On Mon, 2 Apr 2007 19:02:09 -0700, Jugglertwo
wrote:
A student recently asked if the AVERAGE function could be added to the
toolbar as am icon.
This was a good question. I am familiar with customizing toolbars. Also, I
know in the newer Excel versions that the AutoSum icon has the varioius
function listed in the dropdown box.
She wanted to add an icon similar to the AutoSum button that she could
exclusively use for the AVERAGE function. I did not see where this was
possible.
Is this possible? Thanks in advance for any assistance.
Jugglertwo
|