Home |
Search |
Today's Posts |
#1
|
|||
|
|||
find location max value in column
I need to find the cell location of the max value in a column. If I paste the following [from =(cell onwards] into a cell I get the right result. Having a hgard time getting the right VBA code to make this work in an unattended macro. Probably some bonehead mistake on my part, but I cannot find it. Suggestions? GOAL is to make this formula work. Range("z2").Formula = "=(CELL(e1,OFFSET(e1,MATCH(MAX(e1:e100),e1:100 ,0)-1,0)))" TIA, Rob -- rroach ------------------------------------------------------------------------ rroach's Profile: http://www.excelforum.com/member.php...o&userid=21093 View this thread: http://www.excelforum.com/showthread...hreadid=386908 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find a empty cell in next column | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
is it possible to Restrict Find & Replace to 1 column | New Users to Excel | |||
find LAST match in column | Excel Worksheet Functions | |||
Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions |