When we attempt to automate work through VBA, we find that navigating spreadsheet remains an important part of the automation process. In many cases, we need to dynamically navigate and manipulate Excel ranges, just as we would manually — only through VBA code. This chapter presents 14 ready-to-use excel macros for selecting and modifying ranges. macros for selecting and formatting a range, creating and selecting named ranges, enumerating through a range of cells, selecting and formatting all named ranges, inserting blank rows in a range are few of them presented in the chapter.