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.
We charged your card and sent you a receipt
You'll need an account to access this in our app. Please create a password to continue.
Download from the App Store or text yourself a link to the app
Good news! Since you already have a Gumroad account, it's also been added to your library.