CHAPTER 6Creating and manipulating names in VBA
In this chapter, you will:
Learn the difference between global and local names
Learn how to add and delete names
Include information about a name by adding a comment
Learn about the different types of names
Make names invisible
Check for the existence of a name
You’ve probably named ranges in a worksheet by highlighting a range and typing a name in the Name box to the left of the formula bar. You also might have created more complicated names containing formulas. For example, perhaps you created a name with a formula that finds the last row in a column. The ability to name a range makes it much easier to write formulas.
The ability to create and manipulate names is also available in VBA, which ...
Get Microsoft Excel 2019 VBA and Macros, First Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
