VBA – Find the Maximum Value For Each Column in a Range


Find Max Value For Each Column in Range

The following function will return the Maximum Value in each Column in a Range:

We can use a subroutine like the following to display the results:

So:

max each column

Will return 990,907, 992, 976 ,988 and 873 for each of the above columns.

[SPECIAL THANKS TO MIKE RICKSON FOR RESOLVING THE FINERIES OF ARRAYS WITHIN UDF’S ]

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about Easy VBA. A VBA add-in to quickly insert any of the sample code found on our site directly into the Visual Basic Editor, save your own frequently used code, and more!

alt text

Stop searching for VBA code online. Try the Code VBA Add-in…

Learn More!


<<Return to VBA Examples

Did you find this VBA tutorial useful? Then share it with your friends and colleagues:

Leave A Comment