in vba
hi how do i make a formula to give me the average of a strip of data
say a6 until the last piece of data in colomn a
and then
in msg boxs
1)tell me the average
2) the highest value
3) tell me the number of instances
4) how many of these are above a certain number and this as a percentage
please could these numbers also be accesable in the code for storage in the
sheet
thanks guys