ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   max/min of a selected range of cells (https://www.excelbanter.com/excel-programming/308695-max-min-selected-range-cells.html)

Srikanth Ganesan[_2_]

max/min of a selected range of cells
 


Hello All,

How do I find say the maximum/minimum of a selected set of cells ?

Srikanth

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Frank Kabel

max/min of a selected range of cells
 
Hi
msgbox application.worksheetfunction.max(selection)

--
Regards
Frank Kabel
Frankfurt, Germany

"Srikanth Ganesan" schrieb im Newsbeitrag
...


Hello All,

How do I find say the maximum/minimum of a selected set of cells ?

Srikanth

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!




All times are GMT +1. The time now is 10:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com