microsoft excel training class - With Loop

Resolved · Low Priority · Version Standard

Thu 2 Aug 2007, 09:46 Delegate John said...

John has attended:
Excel VBA Intro Intermediate course

With Loop

What is the With Loop used for?

Mon 6 Aug 2007, 16:01 Trainer Carlos said...

RE: With Loop

John

The With loop allows the user to refer to a particular object once while doing multiple actions to it.

eg

With AcitveCell.Font

.Bold = True
.Italic = True
.ColorIndex = 5

End With

Regards

Carlos

Fri 10 Aug 2007, 13:26 Trainer Alan said...

RE: With Loop

Not quite sure what you mean by With Loop, John - the With statement allows you to specify a single object for a series of operations, but is not used with the Loop command.

Can you be more specific - or give a piece of code which will show what you mean?

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips