Feeling at Home on the Range
In This Chapter
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 ...