Need auto average button like the auto sum button.

jts2004

Board Regular
Joined
Apr 21, 2004
Messages
156
I need some code that I can attach to a button in my toolbar that works like Auto Sum, but AVERAGES instead.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Watch MrExcel Video

Forum statistics

Threads
1,114,052
Messages
5,545,730
Members
410,702
Latest member
clizama18
Top