VBA 2007 - Maximum Function

Closed
tixilee Posts 3 Registration date Tuesday 28 August 2012 Status Member Last seen 6 September 2012 - 6 Sep 2012 à 22:44
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 15 Sep 2012 à 07:12
Hi.

On the same worksheet AAA, for each row, I would like to fond thé maximum value between column East and column Ouest.

Is there a vba function? Thanks.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
15 Sep 2012 à 07:12
you dont need vba to find max in ranges

=max(range1, range2)

example
=max(a:a,c:c) to look max value in column A and column C