With… End With Blocks in Excel VBA

By

Power Spreadsheets

The main purpose of With… End With Blocks in Excel VBA 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.

With… End With Blocks in Excel VBA:

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

With… End With Blocks in Excel VBA 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.