View Single Post
  #1   Report Post  
rroach
 
Posts: n/a
Default 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