Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
min value in range
I am having a major problem with the application.worksheetfunction.min()
approach, and I believe it is b/c the range I am referencing is not sorted, and can not be for my application. I have tried the following to find the minimum value in the range without success: Function MyMin(minvaluerange) For Each c In minvaluerange If c < c + 1 Then MyMin = c Else MyMin = c + 1 End If Next c End Function Help would be greatly appreciated. Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Range.Find returns cell outside of range when range set to single cell | Excel Programming | |||
how to? set my range= my UDF argument (range vs. value in range) [advanced?] | Excel Programming |