Return Max Value of given Variables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Keenan Hansen - 03 Mar 2008 22:21 GMT

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.

Reply to this Message

Bob Phillips - 03 Mar 2008 23:08 GMT

You would have to compare one against the other. You could use an array
instead and use the worksheet MAX function on it.

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>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.

Reply to this Message

Keenan Hansen - 03 Mar 2008 23:30 GMT

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"

> You would have to compare one against the other. You could use an array
> instead and use the worksheet MAX function on it.
[quoted text clipped - 3 lines]
> >
> > Any help is greatly appreciated.

Reply to this Message

Bob Phillips - 04 Mar 2008 00:07 GMT

So, are you going to test one against another or use an array?

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> I'm currently sending the variable values to the sheet and then comparing
> any
[quoted text clipped - 18 lines]
>> >
>> > Any help is greatly appreciated.

Reply to this Message

Keenan Hansen - 04 Mar 2008 13:11 GMT

I guess I could write a fairly long set of logical tests, but I was wondering
if there is a quicker way.

> So, are you going to test one against another or use an array?
>
[quoted text clipped - 20 lines]
> >> >
> >> > Any help is greatly appreciated.

Reply to this Message