Determine Largest Variable

[LamboCop]

Hello,

Fairly new to Excel VBA programming and could use some help.

I have 11 variables that will vary in their quantity.

What is the easiest way to determine which of the 11 is the greatest?

The variable names I have are as follows: ac_prod, cc_prod, cran_prod, pb_prod, ss_prod, csa_prod, granola_prod, nuttyap_prod, tm_prod, sac_prod, ms_prod

I did spend some time searching for a similar post but did not find anything relevant to my situation.

Thank you for your help.

Kyle

[6StringJazzer]

It would be easier to do this if these values were in an array, or if they were values in a range in a worksheet. How are you getting the values into these variables in the first place? It would be helpful to have your code.

What are you going to do with it once you find out which one is the maximum? Do you really need to know which variable is greatest, or just what is the greatest value?

[LamboCop]

The values of the varaibles are determined by summing vertically (columns) based on inputs from another workbook.

Yes, I need to know which variable is the greatest.

Displaying the variable name in a msgbox would suffice for this demo.

Thank you

[6StringJazzer]

You didn't say what the data types are for your variables. This assumes they are Long. It's brute force, there's no better way unless we know more details about how the variable values are set.

Please Login or Register  to view this content.

[Andy Pope]

Slight variation to handle ties.

Please Login or Register  to view this content.