With Statement

  1. With object

    1. [STATEMENTS]

    End With

The With statement allows you to perform a series of commands or statements on a particular object without repeatedly referencing the name of that object. With statements can be nested by putting one With block within another. You need to fully specify any object in an inner With block to any member of an object in an outer With block.

Related Topics: While…Wend Statement and Do Loop

More:

Example: