Macro to Calculate Average, Stdev, Sum, and Count From a Column of Data That Changes

Here's my situation. I copy and paste a table of data into Excel from our Datametric software at work. The table can be of varying columns and rows. I want to create a macro where I manually select the column of data I want to work with, run the macro, and then it will output the average, stdev, sum, and count into cells I specify.

If it helps, the Sheet is called "Dump," the cell I want the average output to go into is A5, Stdev B5, Sum C5, and Count D5. I figured I could create a string, set the string equal to selection.address, but from there, I don't know how to go about it. Any help is much appreciated.

Please Login or Register  to view this content.

Well, I've never claimed to know any VBA, but this still made me feel dumb. Thanks a ton, works great!