2.15 - Identify the Max Value with Excel VBA (1)

This video was part of a full Excel VBA course "Excel VBA Exercises and Real-World Projects" which was initially uploaded on Udemy in 2018/2019.
I have since decided to upload the course on RUclips so everyone can watch the content for free.

[@Sancarn]

I would generally avoid using `Range("A" & Rows.Count).End(xlUp)` in favour of `Application.Intersect(MySheet.Range("H:H"),MySheet.UsedRange)`. I would also typically suggest you use arrays rather than looping over individual cells like this. Criticisms aside, it's good you suggest people try alternative approaches out for themselves, and super good that you uploaded these to youtube for free :) Well done

[@KarenTateosyan]

Thanks for your comment, Sancarn...there are many ways to achieve a result, I'm not saying the one I've shown is the most efficient. These are videos I recorded about 4 years ago but I uploaded them as they may help beginners in VBA.

[@jovidonsharifzoda8594]

Your macro helped Me 👍

[@KarenTateosyan]

I'm glad it helped you, thanks for commenting!

[@jovidonsharifzoda8594]

Thank you very much

[@KarenTateosyan]

You are welcome