View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CGeorges CGeorges is offline
external usenet poster
 
Posts: 1
Default Find row number of maximum value

Hello,

my task is as follows:

Look for the maximum of the average grades and display it in a message
box by the MsgBox function.

Now that I found the max. value with

Set myRange = Range("E2", ActiveCell)
max = Application.WorksheetFunction.max(myRange)


how do I get the respective row number?

Any help will be appreciated.

Thanks in advance


---
Message posted from http://www.ExcelForum.com/