| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Min Function on 2D Array
Thanks Alan.
"Alan Beban" wrote: ExcelMonkey wrote: Allan, I cannot get this line to work: MinRow = Application.WorksheetFunction.Min(Array1, 2) I keep getting a "Sub of Function not defined" error. I event tried the following and recieved an "Arguement not optional" error MinRow = Application.WorksheetFunction.Min(Application.Work sheetFunction.Index(Array1, , 2)) Application.WorksheetFunction.Min(Application.Inde x(Array1,,2) Sorry, I left out the second "Application"; it doesn't like Application.WorksheetFunction.Index(...) Alan Beban |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array / Function HELP!!! | Excel Worksheet Functions | |||
| OR function in array-entered IF function | Excel Worksheet Functions | |||
| Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
| need some help with an array function | Excel Discussion (Misc queries) | |||
| Help with an array function | New Users to Excel | |||
Hybrid Mode
