Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

Chapter 6

Feeling at Home on the Range

In This Chapter

arrow Selecting ranges

arrow Navigating the cells in your worksheets

arrow Inserting and deleting blank rows and columns

arrow Limiting range movement

arrow 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346