Max Problem within a range..................

[j33pguy]

Hi,
If i have a range called "Range1", How can i say the following:

-find the cell in range1 that has the max value within that range

-and then do a process (which i have already done) for the columns directly to the left of that cell.


would it be something like:

dim num as double
num= worksheefunction.Max(range1)

??

 

[acw]

Hi

This will show the address of the first cell in rngAg that is equal to the max

Sub aaa()
Set rngag = Range("b1:b15")
num = WorksheetFunction.Max(rngag)
Set ca = WorksheetFunction.Index(rngag, WorksheetFunction.Match(num, rngag, 0))

MsgBox ca.Address

End Sub

HTH

Tony

 

[j33pguy]

that's great! thank you so much! that worked beautifully!
you're awesome!