VBA 2007 - Maximum Function

[Closed]
Report
Posts
3
Registration date
Tuesday August 28, 2012
Status
Member
Last seen
September 6, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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