statements] End With
Data Type: Object
A previously declared object variable.
Program code to execute against object.
Performs a set of property assignments and executes other code against a particular object, thus allowing you to refer to the object only once. Because the object is referred to only once, the “behind the scenes” qualification of that object is also performed only once, leading to improved performance of the code block.
The single object referred to in the
With statement remains the same
throughout the code contained within the
With block. Therefore, only properties
and methods of
object can be used
within the code block without explicitly referencing the object.
All other object references within the
With...End statement must start with a
fully qualified object reference.
With statements can be
nested, as long as the inner
With statement refers to a child
object or a dependent object of the outer