excel macro help

[Nottom]

I don't have a lot of experience using macros, but I am trying to learn. Hopefully this will be pretty simple to those of you who use them regularly.

Essentially, I need to take a selection of data and then output a series of formulas based on them.

Assume that the data is currently selected.

I need (as an example)
A1 = Average(data)
A2 = Stdev(data)
A3 = Count(data)

Any help would be very appreciated.