find location max value in column

Since you're only looking at column E, how about:

Range("z2").Formula = "=""E""&MATCH(MAX(E1:E100),E1:E100,0)"

rroach wrote:
>
> 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

--

Dave Peterson

Dave--works AOK!

Thanks,

Rob