vba training london - VBA

Resolved · Low Priority · Version Standard

Thu 21 Jun 2007, 16:50 Delegate Sharon said...

Sharon has attended:
Excel VBA Intro Intermediate course

VBA

How do I use the "withloop"?

Mon 2 Jul 2007, 10:51 Trainer Carlos said...

RE: 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

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:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips