With… End With Blocks in Excel VBA

The main purpose of is to:

• Introduce a VBA construct known as the With… End With block (or statement); and
• Explain how you can use the With… End With block to improve (among others) the structure and efficiency of your VBA code.

The With… End With block is one of the main constructs you can use to efficiently refer to objects. Since you are bound to work with VBA objects often, you are likely to find the With… End With block helpful.

:

• Is part of my Book Series; and
  
• Assumes you know about the topics covered in: (i) My previous Book Series, particularly the Book Series; and (ii) The previous Books in the Book Series.
  

is divided into three Chapters.

• Chapter 1 is an introduction to the basics of working with the With… End With block.
• In Chapter 2, you learn how (and when) to nest With… End With blocks.
• Chapter 3 contains several practical examples to help you practice creating/improving procedures with the With… End With block.