Need help: after processing a loop for getting the max value, how do we get the variants corresponding to the max value?

[dylan32123]

here is the detail of what am doing and what i want to achieve, thx a lot for your help!

[FONT=arial, courier new, courier, 宋体, monospace, Microsoft YaHei]dim a1 as variant
dim b1 as variant
dim a2 as variant
dim b2 as variant
dim c as variant
dim maxC as variant

for a1 = 0 to 250 step 5
for a2 = 0 to 250 step 5
b1 = calculation with a1
b2 = calculation with a2
if c > maxC then
maxC = c
end if
next a2
next a1

after using this loop how can we get the value of a1 & a2 when the maxC reached?

thx again[/FONT]

 

[Tetra201]

Try this (not tested):

......
If c > maxC Then
    maxC = c
    maxC_a1 = a1
    maxC_a2 = a2
End If
......