Excel Macros For Dummies

Chapter 6

Feeling at Home on the Range

In This Chapter

Selecting ranges

Navigating the cells in your worksheets

Inserting and deleting blank rows and columns

Limiting range movement

Finding and selecting the first blank row or column

One of the most important things you do in Excel is navigate the worksheet. When you work with Excel manually, you're constantly navigating to appropriate ranges, finding the last row, moving to the last column, hiding and unhiding ranges, and so on.

When you attempt to automate your work through VBA, you’ll find that navigating your spreadsheet remains an important part of the automation process. In many cases, you need to dynamically navigate and manipulate Excel ranges, just as you would manually — only through VBA code. This chapter provides some of the most commonly used macros in terms of navigating and working with ranges.

Selecting and Formatting a Range

One of the basic things you need to do in VBA is to select a specific range to do something ...