Excel® 2013 VBA and Macros

2. This Sounds Like BASIC, So Why Doesn’t It Look Familiar?

In This Chapter

I Can’t Understand This Code

Understanding the Parts of VBA “Speech”

VBA Is Not Really Hard

Examining Recorded Macro Code: Using the VB Editor and Help

Using Debugging Tools to Figure Out Recorded Code

Object Browser: The Ultimate Reference

Seven Tips for Cleaning Up Recorded Code

Next Steps

I Can’t Understand This Code

As mentioned previously, if you have taken a class in a procedural language such as BASIC or COBOL, you might be confused when you look at VBA code. Even though VBA stands for Visual Basic for Applications, it is an object-oriented version of BASIC. Here is a bit of VBA code:

Click here to view code image

Selection.End(xlDown).SelectRange("A11").Select ...