Return Max Value of given Variables
I have ten variables in my code, and I need to return which variable is the
highest, and what its name is. Any help is greatly appreciated. |
Return Max Value of given Variables
You would have to compare one against the other. You could use an array
instead and use the worksheet MAX function on it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" <Keenan wrote in message ... I have ten variables in my code, and I need to return which variable is the highest, and what its name is. Any help is greatly appreciated. |
Return Max Value of given Variables
I'm currently sending the variable values to the sheet and then comparing any
irregularities against the set's Mode. I would rather have this run in the code and not be present in any of the sheet's real estate. i.e. x=2 y=2 z=3 Dim Greatest as String Greatest = 'code returns "z" as greatest value msgbox (Greatest) & "is the greatest variable",0,"Variable Info" "Bob Phillips" wrote: You would have to compare one against the other. You could use an array instead and use the worksheet MAX function on it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" <Keenan wrote in message ... I have ten variables in my code, and I need to return which variable is the highest, and what its name is. Any help is greatly appreciated. |
Return Max Value of given Variables
So, are you going to test one against another or use an array?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" wrote in message ... I'm currently sending the variable values to the sheet and then comparing any irregularities against the set's Mode. I would rather have this run in the code and not be present in any of the sheet's real estate. i.e. x=2 y=2 z=3 Dim Greatest as String Greatest = 'code returns "z" as greatest value msgbox (Greatest) & "is the greatest variable",0,"Variable Info" "Bob Phillips" wrote: You would have to compare one against the other. You could use an array instead and use the worksheet MAX function on it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" <Keenan wrote in message ... I have ten variables in my code, and I need to return which variable is the highest, and what its name is. Any help is greatly appreciated. |
Return Max Value of given Variables
I guess I could write a fairly long set of logical tests, but I was wondering
if there is a quicker way. "Bob Phillips" wrote: So, are you going to test one against another or use an array? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" wrote in message ... I'm currently sending the variable values to the sheet and then comparing any irregularities against the set's Mode. I would rather have this run in the code and not be present in any of the sheet's real estate. i.e. x=2 y=2 z=3 Dim Greatest as String Greatest = 'code returns "z" as greatest value msgbox (Greatest) & "is the greatest variable",0,"Variable Info" "Bob Phillips" wrote: You would have to compare one against the other. You could use an array instead and use the worksheet MAX function on it. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Keenan Hansen" <Keenan wrote in message ... I have ten variables in my code, and I need to return which variable is the highest, and what its name is. Any help is greatly appreciated. |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com