microsoft excel training class - 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

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?