vba training london - "with" statement

Resolved · Low Priority · Version Standard

Thu 21 Jun 2007, 09:53 Delegate Petrus said...

Petrus has attended:
Excel VBA Intro Intermediate course

"with" statement

what does the "with" statement do?

Mon 2 Jul 2007, 10:35 Edited on Mon 2 Jul 2007, 10:49 Trainer Carlos said...

RE: "with" statement

Hi Petrus

The With Statement is very useful if you are using several statements in a section of code that apply to the same object.

It stops you having to fully qualify the object each time.

For example:

Worksheets("Accounts").Range("A1") .Font.Bold = True
Worksheets("Accounts").Range("A1") .Value = 47.5

Can be coded as below:

With Worksheets("Accounts").Range("A1")
.Font.Bold = True
.Value = 47.5
End With

Regards

Carlos

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips