Referring to ranges

Next steps

Referencing ranges is an essential part of programming in Excel. Now that you’re getting an idea of how Excel works, it’s time to learn about a fundamental component of any programming language: loops. If you have taken a programming class, you will be familiar with basic loop structures. VBA supports all the usual loops. Chapter 4 also describes a special loop, For Each...Next, which is unique to object-oriented programming such as VBA.