View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.