View Single Post
  #11   Report Post  
Posted to microsoft.public.access,microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
keiji kounoike keiji kounoike is offline
external usenet poster
 
Posts: 199
Default Finding the biggest number out of 8 variables

If you don't make it more clear what you want to do, no one can answer
your question appropriately. Do you want to know the highest value among
some valuables or want to know the variable's name which has the highest
value among some valuables? if what you want is the latter, i think
there is no easy way to know the variable's name or i wonder there is
such a way to know the name. i mean variable's name, not the address of
the variable.

Keiji

Mojo wrote:
Hi All

Does anybody know of an easy way to find out which variable has the highest
value out of 8 variables?

For example, I have these values in 8 vars:

3 0 7 30 37 17 0 7

Although from a human's perspective it's easy to see that the 5th var has
the highest value, how can I chose the appriopriate var programmatically?

Thanks