How to display the higher number out of two columns and add in a third column?

[Test5000]

Hello everyone

I am looking for a short Macro that will display the higher number out of two numbers in two columns.

Example:

A1: 1540
B1: 1420
=> C1 shall display 1540, because 1540 > 1420

A2: 890
B2: 1400
=> C2 shall display 1400, etc.

How can this be done?

I am new to VBA, excuse me if this is already out there somewhere else.

Kind regards,
Test5000

[MickG]

Try :-

Please Login or Register  to view this content.

Regards Mick

[Test5000]

Hi Mick, thanks a lot!
It almost worked perfect, it just displayed the result of the higher in two columns instead of one somehow, but it did what I was asking for.

Thank you

Thread can be closed