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.

#Excel #ExcelTips #ExcelTutorial

[Ahmed-fqsi]

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👍

[pavlinahanusova]

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

[paliscorner]

The TUTOR exhibits a lot of Patience while too

[vijaysahal]

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

[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?

[muhammadwaqas]

Can we Get Notes of these EXcel VBA Videos.