Hello people, i tried to convert "=LARGE((a,b,c,d,e,f),2)" to vba but either i'm doing something wrong or it doesnt work like the formula does.
a,b,c,d... are declared as doubles as they are results of averages.
Please Login or Register to view this content.
Last edited by a.hudrea; 05-11-2016 at 04:38 AM.
Since Large() function accepts arrays not ParamArray
Refer the below code to know how to store your each variable values in a single array variable.
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
uaaaaaaaa :D i didnt know you can do that. Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks