Average macro/program

[Guest]

I am not very familiar with the syntax to write macros. If someone could
give me a step by step on how to do this I would really appreciate it.

I want to be able to highlight any group of cells in a worksheet and run a
macro that will calculate the average of the cell values. I want this
average value to pop up in a small window that I can immediately close and do
again and again. I would also like it to give an error message if there are
cells with text rather than numbers.I realize that this will probably require
some programming in VB. It seems relatively simple but I am not familiar
enough with VB to figure it out on my own.

ANY help would be greatly appreciated.

-CRA

 

[Nick Hodge]

Christopher

Apart from the error bit, you can select any area and right-click in the
status bar and select Average. This will give you a running total of any
selection.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)