LARGE to corresponding text value

  • Thread starter Thread starter Moni
  • Start date Start date
M

Moni

In using this worksheet function
"=LARGE(('FY04'!W2,'FY04'!T16,'FY04'!N27,'FY04'!N39,'FY04'!
Q54,'FY04'!N66,'FY04'!Q77,'FY04'!K114,'FY04'!H128,'FY04'!
T168,'FY04'!N181,'FY04'!K192,'FY04'!D182),1)" - I would
like to know which cell, not the value, was chosen. Then
I would like to retrieve the text of that row, column 3.
Any ideas? Is that possible?
 
Change this from b2,b6,etc to suit your ranges and your sheet.

Sub getlargeinfo()
With Sheets("FY04")
x = Application.Max(Range("b2,b6"))
'or
'x = Cells.Find(Application.Large(Range("b2,b6,etc"), 1))
Application.Goto Cells.Find(x).Offset(, 3)
End With
End Sub
 
Back
Top