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.

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.

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.

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.

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.