Free Excel VBA Course #14 - With Statements in VBA in Excel

In this video, I will show you how to use the WITH statement in Excel VBA.
With Statement allows you to write better VBA macro codes. Instead of qualifying objects, again and again, you can use the WITH statement to refer to an object once and then change it's properties or refer to its methods multiple times.
✅ VBA Course Download files: trumpexcel.com...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
Free Excel Course (Basic to Advanced) - trumpexcel.com...
Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial

[@Ahmed-fq6si]

All your videos are cristal clear and straight to the point. God bless you Sir.

[@Rehankhan_Rrk]

All urs videos are straight to the point and clear... Feeling proud to subscribe u👍

[@pavlinahanusova1595]

A agree with Tim. This one (14) was one of the easiest (but usefull as well)! Thank you, Sumit!

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@shakhobiddinnakiev6767]

thank you , really useful

[@paliscorner]

The TUTOR exhibits a lot of Patience while lecturing.....that's too good......

[@GoGetSP]

Hey Sumit, I am trying to qualify a Worksheet and refer a range of cellssuing With . Why is this giving error? Sub FormatRange() With Worksheets("Sheet1").Range("A1", Range("A1").End(xlDown)) .Interior.Color = vbBlue With .Font .Color = vbWhite .Italic = True .Bold = True End With End With End Sub ---------------------------------- Sub FormatRange() With Worksheets("Sheet3").Range("A1", Range("A1").End(xlDown)) .Value = 30 .Interior.Color = RGB(255, 255, 0) With .Font .Bold = True .Italic = True .Color = vbRed End With End With End Sub This is giving application defined error?

[@muhammadwaqas1838]

Can we Get Notes of these EXcel VBA Videos.

[@vijaysahal4556]

nice sir thanku plz make a video class with statement for practical Exmaple

[@abhinaygarg7029]

Thank You

[@manishkumarchd]

super