Thread: calculate Min and Max Values of selection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bandy2000 bandy2000 is offline
external usenet poster
  
Posts: 26
Default calculate Min and Max Values of selection
HI
I have a range selected as following:

Range(ActiveCell, ActiveCell.Offset(NumMeasPerPix - 1, 0)).Select

How can I do calculations with the data in that selection e.g. get the Min
or Max Value or the Mean Value? Those are all available in Excel. How can I
make them available programatically?
Is it possible to store the result in a different worksheet? How?

Thanks

Reply With QuoteReply With Quote