ExcelGeek
Not sure how to use the code example you show here - what does aplication.large return
ExcelGeek
Not sure how to use the code example you show here - what does aplication.large return
Last edited by Rasm; 06-18-2011 at 10:26 AM. Reason: typo
xl2007 - Windows 7
xl hates the 255 number
Excelgeek
I got this working - so that is cool - anyway I can get the coordinates of the elements as well - so I know the position in the array where it found the ranked value?
It seems that the WorksheetFunction.Match is the one to use - to find the position in the array - But my array is 20 by 20 - so I cannot get Match to work
Code:Avar=Application.WorksheetFunction.Large(CorrelMatrix, 1)
Last edited by Rasm; 06-18-2011 at 08:13 PM.
xl2007 - Windows 7
xl hates the 255 number
Posting Permissions
Reply With Quote
Bookmarks