vba training london - VBA

Hi Sharon

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